Hi, hopefully a simple problem to explain and solve!
I have an excel table containing many cells of text. The text includes quotes. I am looking for a way to find and replace the quotes to make them italic or bold.
Hi, hopefully a simple problem to explain and solve!
I have an excel table containing many cells of text. The text includes quotes. I am looking for a way to find and replace the quotes to make them italic or bold.
Quotes are all different but between ".
You could try using Conditional Formatting, to find ", but that will highlight the whole cell.
If thats not what you want, then you will only be able to do this with VBA
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yup think VBA needed!
Thread moved accordingly and title augmented.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
The below code makes the characters between the quotes bold but, does not remove the quotes;
Select the range with your mouse and run the macro named "Test"
Please Login or Register to view this content.
Last edited by Haluk; 07-10-2020 at 05:55 AM.
Works great thanks.
Hi
and if you want both bold and italic, you could..
zeddyPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks