shonshon
10-22-2008, 01:58 PM
Hi,
My Excel file has a column that has hundreds of text that I need to replace them with other text
for example:
Monica to cooks
John to jsmith
etc.
the find and replace command in Excel do this one at a time. I want to write a macro that I put into it all the text that needs to replaced and the corresponding text (e.g. Monica and cooks) and etc. and it does this for me at once
Thanks alot
Shon Shon
My Excel file has a column that has hundreds of text that I need to replace them with other text
for example:
Monica to cooks
John to jsmith
etc.
the find and replace command in Excel do this one at a time. I want to write a macro that I put into it all the text that needs to replaced and the corresponding text (e.g. Monica and cooks) and etc. and it does this for me at once
Thanks alot
Shon Shon