Stripping a line

I

insane

Hi. I`m new here and just wanna know something.

I`ve got a .txt doxument with about 3000 lines in it that has to b
split up into different colums at certain markers. could someone pleas
help me out.

underneath i`ve added one line from the document.

60911477190560@MISS@NE@laka@149 BRIDGE MANSIONS@333 CELLIER
STR@SUNNYhill@@0002@149 BRIDGE MANSIONS@333 CELLIER
STR@SUNNYHILL@PHALA@0902@VISAGIE STR@PHALA@806-7587/8463.@MR KLO
30803@1057@6702032453085@19671235405@081243350927@011231231238831@ELIZABET
DRIVE@PHALA@30123-0885 312354087095/6@WAITER@14277\
 
M

Myrna Larson

You didn't say what the markers are. The @ symbols? If that's correct and you
want to split at EVERY @ symbol, use Data/Text to Columns. It has a "Wizard".
There's more information in Help if you need it.
 
Top