LinkBack URL
About LinkBacks
Does anyone know of a formula that would extract only underlined text from a text string?
Thanks
Does anyone know of a formula that would extract only underlined text from a text string?
Thanks
I'd recommend asking a moderator to move your post to the VB Forums. There's nothing I know of that doesn't incorporate VB or at least a User Defined Function to accomplish this.
Maybe a looping macro that checks every nth character's Underline property and returns them as a string?
Thanks for the suggestion.
Maybe a UDF
Remark: extracts the underlined text, but the results are not underlined. Is it ok?
Usage
Please Login or Register to view this content.
B1
=Underline(A1)
copy down
A B
Some text and more underlined text text underlined text Text not underlined Some Text Some Text More New Text underlined New Text
Marcelo Branco
I think I had the right idea and it looks like it works!
Thanks Marcelo!
Yes your idea is perfect.Maybe a looping macro that checks every nth character's Underline property and returns them as a string?
You are welcome.Originally Posted by daffodil11
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks