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