import and saving data

  • Thread starter Thread starter lsc
  • Start date Start date
L

lsc

I import a file and it is formatted n text but t text group has a
number of values that want in separate cells. Iam lost on how
to do that. Another issue is how do i save a spreadskeet in
comma or text format.

Import file format, e.g.,

123 ws 345 154 (all n a single cell) but what I want to do is
format the data were each group of numbers or letters are in a
separate cell.

iF I receive the above as 123,ws,345,154 how can I mport data nto
separate cells.
Thanks
 
Hi

With your data in column A, select the entire column, goto Data >
TextToColumns > Delemited > Delemiters: Space > Finish


To import a csv file, just goto Open files, and choose 'Text Files' in
'Files of type', and open the file...

Hopes this helps.
....
Per
 
Back
Top