Search, Find and Change

[zinzah]

Hi All,

My dp dept supplies an xls file that must be manually edited and saved as a .csv to post to a website.

The manual edits are:

find all the cells that are BOLD and add the html tags (<b> and </b>) to the value of the cell without changing the original entry

and

find all the cells that are RED and add the html tags for that

then save the file as a .csv.

I am so swamped with other stuff and I can't give this the attention it deserves.

Can anyone offer any help?

[royUK]

What version of Excel are you using? Excel 2003 has a FindFormat feature.

[zinzah]

Thanks Roy! I was working on it late last night and came up with the following, which works perfectly!

Please Login or Register  to view this content.