seperating columns - help newbie

R

razoruser

HI,
I have a text file with 2 columns of data. The two columns are exactly
spaced by 8 spaces.
I want to copy these two columns in the text file as seperate columns
in an excel sheet. How do I do this?

Thanks
ss
 
N

Norman Jones

Hi RazorUser,

With the data selected, try:

Data | Text to columns | Delimited | Check 'Space delimiter |
Check 'Treat consecutive delimiters as one' | Next | Finish

If the data contains other spaces, as a precursory step, replace the 8
spaces with a character which will not appear in your data. Then use the
replacement character as the delimiter in the Text to Columns process.
 
D

Dave Peterson

If you meant that each field is exactly 8 characters wide (not separated by 8
spaces), then you can copy all the data from notepad(?) and paste into one
column.

Then select that column
data|text to columns
fixed width.
Draw a line between the 8th and 9th character and remove any that excel guessed.

You could also name that text file something.txt.
then File|open that text file and you'll see a very similar wizard pop up.
 
Top