Delete all text which is not 'bold' in cells with 'mingled bold' text

**Excelfriend** · 01-23-2010, 12:13 PM

This is a following up of a former thread of mine, see http://www.excelforum.com/excel-prog...bold-text.html.

I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.

Is this possible?

Perhaps a hint is (I don't know) to start from the useful formula of PMO which he gave me in the above mentioned former thread :

Please Login or Register  to view this content.

Thanks.

**MickG** · 01-23-2010, 12:52 PM

Hi, Try this:-

Please Login or Register  to view this content.

Regards Mick

**mrice** · 01-23-2010, 12:57 PM

Try this function

Please Login or Register  to view this content.

**Excelfriend** · 01-23-2010, 04:37 PM

Dear Mick,

Your macro works very nicely! Thank you very much.

**Excelfriend** · 01-23-2010, 04:47 PM

Dear Martin,

Thank you also very much for your solution with an UDF!
In first instance the function didn't work, but after I declared the variable 'n' he works nicely.

Please Login or Register  to view this content.

Thank you again!

Delete all text which is not 'bold' in cells with 'mingled bold' text

LinkBack

Thread Tools

Rate This Thread

Display

Delete all text which is not 'bold' in cells with 'mingled bold' text

Re: Delete all text which is not 'bold' in cells with 'mingled bold' text

Re: Delete all text which is not 'bold' in cells with 'mingled bold' text

Re: Delete all text which is not 'bold' in cells with 'mingled bold' text

Re: Delete all text which is not 'bold' in cells with 'mingled bold' text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions