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

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?

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.

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mmmcdee

ASKER

PERFECT! Thank You!

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