Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi - I am trying to have my spreadsheet either replace numbers with a
corresponding name, or, if it's easier, add a column with a name. That is, I have the following data: 123 345 357 I want my spreadsheet to either: 1. Replace 123 with Bob, and replace 345 with Jane, and replace 357 with David. The result would be Bob Jane David Or 2. Add in a column so that the result is - 123 Bob 345 Jane 357 David Is there a way for me to do either of these" Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Substitute/Replace | Charts and Charting in Excel | |||
my excel formulas are too long to execute find and replace | Excel Worksheet Functions | |||
Formula help! Find and replace in formulas | Excel Discussion (Misc queries) | |||
Substitute ,replace and delete in a cell. | Excel Worksheet Functions | |||
changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) |