separating text and numbers contained in one cell

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
 
C

CLR

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
 
Top