"EyeGorePS" wrote
in message ...

The data is in a text file and has not been imported or opened in excel.
The data is: john414 mary556 tim238 etc. I would like to place the
document into excel so that all the names a

john414
mary556
tim238

I am brand new to excel and do appreciate any help.

Gord's Data/ Text to Columns recommendation will produce a row of data.
Select that data, Cut, then Paste Special/ Transpose to give your column.

Another option is to use an editor on your text file, and replace space by
paragraph mark.
--
David Biddulph