cleaning text

[rowk]

I have a cell containing the text
sydney 2000

I want to delete the 2000


Any suggestions?

thanks

 

[royUK]

Hi

Download the asap addin for free from http://www.asap-utilities.com. Take a look at the Text submenu and you can delete all numbers in a selected range to leave the text characters

 

[Aladin Akyurek]

You can also apply Data|Text to Columns to your data with Delimited as option and Space as delimiter. You can delete the column with numbers that you will get.

 

[Legacy 98055]

Find and Replace would be an option as well.
Replace with blank.

 

[rowk]

thanks - i decided to go with the replace option - it required less brain cells to execute.