delete part of text from a cell

[Guest]

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

 

[Lori]

Try Edit > Replace with Find: party date . (Replace blank)

 

[Beege]

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

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

Beege

 

[Guest]

thanks a lot

 

[Guest]

thanks a lot

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

Beege