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.
Bookmarks