delete part of text from a cell

A

andresg1975

lets say i have a cell:

party date 06/04/06

how can i delete "party date" and keep 06/04/06 using a function.

i have a complete column that i would like to change

thanks a lot for your help
 
B

Beege

andresg1975 said:
lets say i have a cell:

party date 06/04/06

how can i delete "party date" and keep 06/04/06 using a function.

i have a complete column that i would like to change

thanks a lot for your help
Click to expand...

You could use Data/Text to Columns, and not import the words. Use space as
your delimiter

Beege
 
Top