Finding & replacing words/numbers within a spreadsheet

[Compworld]

Hello,

I need to manually edit a spreadsheet file, and I was wondering if there is a program that could help assist me in doing so. For example, I need to find certain letters within a cell, and replace them with a certain number. So, if I wanted to replace the following A special wedget with the number 1234, how can I replace place that whole cell with the number? Currently, I can only do a search within Excel and replace the single word with a number, but the rest of the letters are still there. Is there anyway or program to search for a particular word within every cell and replace the entire contents of the cell with the number?

I have so many of these cells to correct, that if I have to do it manually, then it would take me days every week.

If any knows of a way or a program that can do this, please let me know.

Thanks,

CompWorld

[gph]

If you know JS or VBScript and are using windows you can write an hta to do that. There's not alot of info on the web about this other than MSDN. Any info that is out there however is mostly regarding Excel. If you're interested try a search for "Excel.Application" Someone might have already written something similar to what you want.

[gph]

Just thinking, I've never used Excel but it should record macros. You can record a macro then view the scripting that runs it.

[aspdaddy]

Its very easy to do within Excel, there are similar scripts for what you need here:
[j-walk.com...]

[gph]

Well that's easier, thanks aspdaddy