How do I split "A1B2" into "A1" and "B2" using text to column fun.

G

Guest

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
 
N

Nick Hodge

Jennifer

Is there always a pattern, split in half, three/three, etc. or is it split
after the first numeric?

Let us know for a solution

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split text into columns 1
Text To Column max 26 characters 7
Split with consecutive delimiters 5
split text into more columns excel 1
Need to split large text field 13
Text to Column with fixed width in VBA 1
How to split text? 9
How do i split text from 1 column into 3 columns 3

Top