Thread: Any Excel pro's? Need trimming sentences from other cell
View Single Post
Old 01-23-2010, 08:18 AM  
NemesisEnforcer
Confirmed User
 
NemesisEnforcer's Avatar
 
Industry Role:
Join Date: Aug 2003
Location: Vegas and Los Angeles
Posts: 2,122
Quote:
Originally Posted by Naughty View Post
Any idea how to combine this with some html character strip function? There's html in the long descr. causing layout issues when stripped.
How much HTML formatting do you have in the first 20/25 characters? You could highlight the column then use Replace to change the HTML code to null.
__________________
The Only Time When Success Comes Before Work Is In A Dictionary.

Did you ever notice: When you put the 2 words 'The' and 'IRS' together it spells 'Theirs.'
NemesisEnforcer is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote