Using Split

[Rick_Stanich]

I cant seem to figure out how to use "Split". I searched in this forum and found a few posts but I did not understand the solved ones.

I have data in many rows in this format:
$$ #901,11d3,[-B-] Ø.2494 +.0005/-.0000

The first thing to do is get rid of "$$ ", no biggie.
Second is to split the data up based on the "," comma location. The above data would read
#901
11d3
[-B-] Ø.2494 +.0005/-.0000

Each being in its own cell by "columns", thus the above break down would be in A2, A3 and A4 respectively assuming the original data is in A1.

Some strings of data can be over a hundred characters in length with multiple commas.

Tips, hints or code is always appreciated.

[shg]

Why not just use Text to Columns, Rick?

[c.vaibhav]

Hi,
You can use the following Macro,

Please Login or Register  to view this content.

Just select the Column where you want the split to take place.

Select one column at a time that doesn't have anything on its right side as it may be lost.

@shg -- Saw your reply after writing this post. Text to column is a great and a simple idea. I dont know how it slipped out of my mind.

[Rick_Stanich]

I cant seem to find that in Excel 2000, is it in the help file?

Found it, perfect!

Thanks guys!

[royUK]

Shg is referring to Data menu -> Text to Columns