Splitting a string of numbers and letters in to multiple rows

[muddbog]

I wanted to know if anyone could help me, I have a column of data that I need to split up in to multiple columns. I know how to do this with text to columns but I am trying to save my self a little time with maintaining my database. and I thought I might be able to do this with Visual basic.

What I have is a string that looks like this:

235/50R17 99Y

I also have other strings that look like this:

325/25R20 101W

What I would like is some way to automate splitting this up into the separate columns like this:

235 50 17 99 Y
325 25 20 101 W

[p24leclerc]

you'll always have 5 columns to create, right? Where are your data? In column A? Where do you want your new data? Will it alsways be in the same format, I mean nnn/nnLnn nnnL where n is for number and L is letter?

[muddbog]

It will always be 5 columns, the R won't be used and it will always be in the same format however the PITA is that the last number set varies in the number format between 2 and 3 numbers:

nnn nn nn nn l or nnn nn nn nnn l


and the data will be aquired from column "a" and will be put in to "b c d e f"

[p24leclerc]

See at attached workbook.
The following macro is part of it.

Please Login or Register  to view this content.

[muddbog]

does it matter that I'm on a Mac, because I get an error saying unable to create object

[xladept]

HGi muddbog,

Here's another option:

Please Login or Register  to view this content.

[muddbog]

HGi muddbog,

Here's another option:

Please Login or Register  to view this content.

Perfect! Works Exactly as I wanted! Major Kudos!

[xladept]

Hi muddbog,

Glad you like it! And, thanks for the rep!