| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace text with text
I have text within a cell that I need to replace with differenct text so I
can so a vlookup. Example: FDA1510 needs to become CA1510, there are about 160+ cells that need to be changed. I have tried the replace function, but it seems I am not putting the correct information in, or I don't know how to show the result instead of the function. When I put in the function I don't get an error message, the cells only shows the function. Thanks! AH |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replace text with text
Hi,
what version of Excel are you using? Show us the formulas. In general replace CA1 with FDA1 should work with whole cell unchecked. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "AH" wrote: I have text within a cell that I need to replace with differenct text so I can so a vlookup. Example: FDA1510 needs to become CA1510, there are about 160+ cells that need to be changed. I have tried the replace function, but it seems I am not putting the correct information in, or I don't know how to show the result instead of the function. When I put in the function I don't get an error message, the cells only shows the function. Thanks! AH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find part text, replace all text | Excel Discussion (Misc queries) | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| How do I change replace text in a cell for different text? | Excel Worksheet Functions | |||
| How to replace a text with another | Excel Worksheet Functions | |||
Linear Mode
