delete part of text from a cell
 

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

delete part of text from a cell
 

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

delete part of text from a cell
 

"andresg1975" wrote in message
...
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

delete part of text from a cell
 

thanks a lot

"Lori" wrote:

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

delete part of text from a cell
 

thanks a lot

"Beege" wrote:

"andresg1975" wrote in message
...
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