separating text and numbers contained in one cell

  • Thread starter Thread starter dwr
  • Start date Start date
D

dwr

We received a spreadsheet from a customer, containing data which w
would like to improt in to a database. The problem is the numerica
values and text descriptive fields are contained in one cell. Is ther
a way to grab all text in a spreadsheet and move it over one colum
leaving it in the same row? What I would like is for the numbers t
stay in column one and the descriptive text to be cut/moved in to th
adjacent cell in column two.

Any help is appreciated.


Thanks,

DW
 
Assuming the numbers and text are consistant, like addresses (1234 Alameda),
then you could use the Data > Text to columns feature using a space as a
delimiter............

Vaya con Dios,
Chuck, CABGx3
 
Back
Top