Hi,

I have a spreadsheet populated with the following type of data:

xyz,"90,500","110,000"

xyz2,"33,100","18,100"

Its 200 cells and all have a mix of the above characters, it was imported
from a system so appears like this. I need to tidy up the data so it removes
everything besides the letters i.e. xyz should remain but all the numbers and
special characters like " " and , should be removed.

Dont think text2columns will work or the =LEN formula.

Any help would be greatly appreciated.

Thank you.