| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find and Replace Text
Here is my problem. I have the following text replicated hundreds of times
throughout my spreadsheet. 'Oct 2003 and 'Nov 2003 and other similar text strings. I would like to do a find and replace on the year 2003 to 2004. When I do this Excel changes the cell from text to date. How do I keep Excel from doing this. Note that the cell must remain as text and that I can not just reformat the cell as the string is a dimension name in an external OLAP cube, that Excel References... Thanks in Advance Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find part text, replace all text | Excel Discussion (Misc queries) | |||
| Find & replace with text | Excel Discussion (Misc queries) | |||
| Replace can't find text | Excel Discussion (Misc queries) | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find & Replace in Text Box | Excel Discussion (Misc queries) | |||
![Jim Thomlinson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
