Remove Leading Character in List

[Mike_Dean]

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

[shg]

Maybe =if(left(a1)="x", mid(a1, 2, 255), a1)

Or if they really ALL start with x, just =mid(a1, 2, 255)

[Mike_Dean]

Maybe =if(left(a1)="x", mid(a1, 2, 255), a1)

Or if they really ALL start with x, just =mid(a1, 2, 255)

See.. So quick and simple..

Where would I be without you lot..

Thanks so much for such a speedy resolution...

The second one will suffice as the ALL start with an X


Cheers,
Mike