Avatar of mmmcdee
mmmcdee
Flag for United States of America asked on

Data parsing Excel cells

I am trying to parse through cells that  -
1 - Whenever a number is followed by a letter;  split apart.  
2 - Whenever a letter is immediately followed by a number; split apart.

 I have a formula in the attached Excel Doc - although I cannot get it to run properly.

Thanks
Microsoft Excel

Avatar of undefined
Last Comment
mmmcdee

8/22/2022 - Mon
Saqib Husain

File
mmmcdee

ASKER
Sorry about that -
Book7.xlsx
Martin Liss

Would you settle for VBA code, and if so given your text in A5, what do you want to see in B5?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
mmmcdee

ASKER
That is Exactly what I need.  I think my formula path is the wrong direction.
Martin Liss

What should B5 look like?
mmmcdee

ASKER
B5 would be the split apart parsed data from A5.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

I understand that you want to parse the data. Please SHOW me what it should look like.
mmmcdee

ASKER
I highlighted the changes in B5 on the attached spreadsheet - how the parsing would change A5 to B5.

1 - Whenever a number is followed by a letter;  split apart
2 -  Whenever a letter is immediately followed by a number; split apart.

The coloring s for reference only of course.
Book7.xlsx
ASKER CERTIFIED SOLUTION
Saqib Husain

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mmmcdee

ASKER
PERFECT!  Thank You!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Patrick Matthews

mmmcdee,

You state:

1 - Whenever a number is followed by a letter;  split apart.  
2 - Whenever a letter is immediately followed by a number; split apart.

On that basis, please explain why for your sample value:

Red 4 door FWD Sedan 4-Speed Automatic 3.8L V6 12V MPFI OHV Stock# B29954A.

your sample answer does NOT put spaces between V & 6, 12 & V, or B & 29954 & A.

Patrick
mmmcdee

ASKER
Patrick -
Apologies on my first Book7.xlsx.  The second posting within this thread had the spaces I was looking for.  

A Side Note:  I posted another question pertaining to 'removing' white space - this one is tough. see:  Removing White Space Between Numbers in Excel

Thanks -
M