Macro to separate data

[MyBabyO]

I'm looking for a macro that can take data that is in one cell with hard returns between the fields and separate it into columns. I need like data in the same columns. For example, my cells might look like this:

"EXISTING INFO
Route 11
BFO576(R)
3.6 kft"

I need 4 columns from this data, but the next cell might only have 3 pieces of that information, but I need all of the "ROUTE" data in one column, all of the "BFO" data in a column and all of the "kft" in one column so that I can sort by any piece of that puzzle.

How could I do this if all cells don't contain all 4 pieces of the puzzle?

Many thanks in advance!

[shg]

Welcome to the forum.

Post a workbook with some examples of the data.

[MyBabyO]

Here is a workbook example. Thanks so much!

[shg]

Try this:

Please Login or Register  to view this content.

[MyBabyO]

That worked beautifully - except for the cells with three lines in them - they skipped the BFO sections when they separated - any idea why?