Using search and replace is changing the cell format

[neeraj_chow]

I am using excel 2007. I have around 9K rows and 5 columns of data. The first column has one or two words in bold and punctuated by a full stop and rest of the words in this column is separated by a comma and is of a regular font without any formatting. I want to replace all such comma with a semi colon. But when I try to use the search and replace method/command to replace, then after the replacement the entire cell format also changes to bold. I tried various possible ways to curb it but nothing works but am unable to change this behavior of excel.

Need some insights how can I change the , to ; without the cell format getting changed/applied to the entire cell after the replacement.

Thanks

 

[István Hirsch]

After performing any function (for example replacement), Excel restores the common font format that had been set for the cell so what you need is not possible this way. The common format will be restored even if you replace a space with a space.<o></o>
What you need is possible with a macro: it preserves the individual substring formatting in the cell during replacing; or you can perform the replacing in Excel and then do the neccessary formatting in the whole range of cells with a click of a button.<o></o>
Visit: http://youtu.be/aN7cIWsz95E<o></o>
http://www.excelfindandformat.herobo.com