| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Replacing Values in Cells Via Formula
I have a column in a spreadsheet with nearly 400 rows of data. Everywhere an 'X' appears in a cell in the column, I'd like to replace it with the date '1/18/05'. Can anyone tell me how to do that please? Thanks in advance for any help. -- pclutts ------------------------------------------------------------------------ pclutts's Profile: http://www.excelforum.com/member.php...o&userid=26129 View this thread: http://www.excelforum.com/showthread...hreadid=483880 |
|
#2
|
|||
|
|||
|
Replacing Values in Cells Via Formula
Nevermind. I figured it out. I used the Replace function. Duh! I guess I couldn't see the forest for the trees. -- pclutts ------------------------------------------------------------------------ pclutts's Profile: http://www.excelforum.com/member.php...o&userid=26129 View this thread: http://www.excelforum.com/showthread...hreadid=483880 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| If formula that looks at multiple cells and values, and then calul | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
| How to display the "values" included in a formula vs. the cells? | Excel Worksheet Functions | |||
Hybrid Mode
