I would like to have a user-defined function that extracts the bolded portion of the text in a cell that has some normal and some bold font. For example, if cell H5 contained:
A Nx Sc N
and the Sc was bold and everything else was normal (sorry, I couldn't get the bold to work in this message)
then my user defined function =GetBold(H5) would return "Sc".
Thanks for your help.
Last edited by FDibbins; 06-28-2015 at 07:41 PM.
Hi and welcome to the forum,
One way
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
That worked just the way I wanted - thanks very much!
Glad to have helped and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks