This would appear simple, but its doing my head in.

I have a long list of part numbers that start with the letter X.

I want to remove the X from the part number, the problem is the X can also appear elsewhere in the part number but I need that to remain in place.

Eg..

X1234X-H

needs to be

1234X-H


and

XX1234-X2

Needs to be

X1234-X2.


Its always the leading X, that needs to be rmeoved.

The other X could appear in any location (apart from the beginning), and needs to remain in place.


Thanks,
Mike