Thread: How do I split "A1B2" into "A1" and "B2" using text to column fun.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jennifer Jennifer is offline
external usenet poster
  
Posts: 385
Default How do I split "A1B2" into "A1" and "B2" using text to column fun.
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
Reply With QuoteReply With Quote