Text file imported into Excel - Need help separating the data into two columns

Stormy4757

New member
Joined
Dec 26, 2013
Messages
11
Reaction score
0
Points
0
I have a text file that is imported into Excel. The information is all in one cell, in the first column. Looks like this:

HGRISKO1,AADURAN
AGRISKO,AEGRAFS

I want to separate the two words into two columns and delete the comma. So it would look like this:

AGRISKO1 AADURAN
AGRISKO AEGRAFS

Is there a fast way to do this? I have over 40,000 lines of text.
 
Nevermind, I figured it out. I imported it by using the comma delimited feature.
 
Back
Top