How to replace Character *

[serhat]

I have an excel spreadsheet with a detailed listing of data. I am onl
interested in the totals by category. The totals are given after
detailed listing with * being the row identifier. Is there anyway I ca
replace the character * with total. I cannot do a search and replace a
it replaces the complete data in the sheet.

I need this for a vlookup where I will concatenate the * anothe
identifier. The Vlookup chokes because it cannot handle the
character. Any ideas or some advice for a workaround?

Thanks a lot!

S

 

[Peo Sjoblom]

Replace what ~*

precede any wild card characters with tilde

 

[serhat]

Thanks Peo. That is just what I neede