Dear all:
I have data stored in Excel with the format of "XY1AB2" which is alway a
series of alphabet follow by a digit. I would like to split the text into
columns "XY1" and "AB2". I am currently manually puting space between XY1 and
AB2 and run "text into columns" and use space as the delimited marker. It
takes a lot of time. i am wondering if anyone can help with a macro or a
solution for this? Thanks.
Any help will be appreciated.
Jennifer