Find & Replace but preserve font & format

[Exgirlfriend]

I have a cell which contains a paragraph with words that are bold, some words are strike through, and other words are italicized. I find & replace one word in the paragraph and the whole cell loses the format. How do I prevent this from happening? I have multiple sheets that need to be combed through. To resolve the issue, I looked all over online and message boards but still have not found a solution.

Any help with be appreciated!
Your Ex-Girl

 

[Domenic]

Have a look at the following link...

How to find and replace text then preserve formatting in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

Hope this helps!

 

[Exgirlfriend]

Thanks for the response! I do appreciate it. I saw that one but I believe it only works with the text that is being found and replaced. My focus is the other data within the cell - how do I preserve that texts' formatting.

 

[Exgirlfriend]

Have a look at the following link...

How to find and replace text then preserve formatting in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

Hope this helps!

Thanks for the response! I do appreciate it. I saw that one but I believe it only works with the text that is being found and replaced. My focus is the other data within the cell - how do I preserve that texts' formatting.

 

[Domenic]

Actually, it does preserve the formatting. Have you tried it?

 

[Exgirlfriend]

Actually, it does preserve the formatting. Have you tried it?

HA! I think I found the issue. My cell has more than 255 Characters. Had no idea excel has a limitation. I did a couple of google searches to see if I could resolve that issue. Looks like it is problematic. Do you have the workaround? Thanks for stating the obvious for me. . .

 

[Akuini]

@Exgirlfriend
As a work-around.
Can you copy your data to Word?
Word can deal with text formatting much better than Excel.
Edit your data in Word then copy it back to Excel.

 

[Exgirlfriend]

@Exgirlfriend
As a work-around.
Can you copy your data to Word?
Word can deal with text formatting much better than Excel.
Edit your data in Word then copy it back to Excel.

The issue is I have a workbook with about 500 tabs so that would be a lot of copying and pasting.

 

[Akuini]

I have a cell which contains a paragraph with words that are bold ...

1. Do you only deal with a single cell on each tabs?
2. And in that cell do you have a single line or multiline data? There's a problem if you have multiline data, that is if you copy it to Word then copy it back to Excel then it will be pasted in separate cells.
3. Can you give an example of "find & replace " that you want to do?

The issue is I have a workbook with about 500 tabs so that would be a lot of copying and pasting.

I think it's doable by using macro in both Excel & Word. But my VBA for Word is a bit rusty, so if the solution would be a bit complicated then I'm not sure I can help you. But maybe some experts in Word VBA could help you, like @shg .

 

[Exgirlfriend]

1. Do you only deal with a single cell on each tabs?
2. And in that cell do you have a single line or multiline data? There's a problem if you have multiline data, that is if you copy it to Word then copy it back to Excel then it will be pasted in separate cells.
3. Can you give an example of "find & replace " that you want to do?


I think it's doable by using macro in both Excel & Word. But my VBA for Word is a bit rusty, so if the solution would be a bit complicated then I'm not sure I can help you. But maybe some experts in Word VBA could help you, like @shg .

I'll strike out on all of the above. . .

1. Do you only deal with a single cell on each tabs?

. . . multiple cells. About 15 rows and 3 columns for each sheet

2. And in that cell do you have a single line or multiline data? There's a problem if you have multiline data, that is if you copy it to Word then copy it back to Excel then it will be pasted in separate cells.

Multi-line Data. I'm thinking it might be good to split the cells. I have a good "breaking point"

3. Can you give an example of "find & replace " that you want to do?

Think of AM and PM. Activities that were done in the AM and activities done in the PM. I want to go through and delete the AMs and PMs so I can assign them to their own cell. I thinking about doing a text to columns function but once again, I run into losing the formatting when I do the split. Would that be more efficient? I have looked online but most of the forum is dedicated to merging cells and not splitting the cells. I'm super new at this so sorry for my lack of education and detective work at finding the right message boards!