Hello - I am not fluent in vba macros....
I have a spreadsheet that contains several cells that contain text that contain the phrase "Select". For example:
"This is part of the string. (Select only its part to italicize)".
Here's the catch. The portion of the string that starts with "(Select" may vary from line to line.
(Select one)
(Select up to 5)
etc...
I tried using find and replace with wild cards but it applies the italics to the entire string.
I've looked up some VBA code but haven't gotten it to work.
Any suggestions are welcome. Thanks!
I have a spreadsheet that contains several cells that contain text that contain the phrase "Select". For example:
"This is part of the string. (Select only its part to italicize)".
Here's the catch. The portion of the string that starts with "(Select" may vary from line to line.
(Select one)
(Select up to 5)
etc...
I tried using find and replace with wild cards but it applies the italics to the entire string.
I've looked up some VBA code but haven't gotten it to work.
Any suggestions are welcome. Thanks!