Hello,

Been a lurker for a long time, found tons of quality information here. Decided to register so I could use the local search engine. Finally making my first post.

I have a single column with a series of text data (it's always the same column). I would like to truncate the text to 9 characters if, and only if, the cell in that column begin with X. I would like to do this through a macro.

Help?

Thanks in advance

Example....
Before:
X123456789101112
X567891012345
P123456789101123
Z123456489798130

After:
X12345678
X56789101
P123456789101123
Z123456489798130