| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Letter Replace Help!!
Hi everyone
In Range("B2:B8000") I have number + "D" + number code in each cell. i.e. 1.1D3, 2.3D4 etc. I am just trying to replace the "D" to "E" by Ctrl + F - Replace but when I do it, it makes it in to horrible numbers :( i.e. 1.1E1 as 11, 1.1E2 as 110 so on. How do I just change that "D" from the code? Thank you for your help in advance Regards James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does excel replace letter m with a 1 every time | Excel Discussion (Misc queries) | |||
| How to replace the last digit in a cell with a letter | Excel Discussion (Misc queries) | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| Replace Letter "E" with Letter "C" for 200 Different Sums in a Col | Excel Worksheet Functions | |||
Threaded Mode
