View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jkollenbroich jkollenbroich is offline
external usenet poster
 
Posts: 1
Default Character search and replace

I need help with a problem, and I do not know if this is even possible.

Lets say cell A1 = 123ABC

On a different sheet we have a text chart which shows 123 equaling United
States. "A" equals great, and "BC" equals country.

Is there a way to search the first sheet, and get cell A2 to return a text
of "United States great country"?

This is course is a very simplifies version of what I need to do, as I have
several hundred different sets of values I need to convert to text.

Please help.