Remove specific text from only certain cells

**amoorman** · 02-09-2009, 07:29 AM

Hi thank you very much,

As you can see in column B there is some irrelevant data. How can i remove this?

Many thanks

Ashley

**Richard Schollar** · 02-09-2009, 08:31 AM

Hi Ashley

try this formula in C2 copied down:

=SUBSTITUTE(SUBSTITUTE(B2,"&",""),"nbsp;","")

Richard

**amoorman** · 02-09-2009, 08:48 AM

AH! I had never used substitute before.
Your solution is nearly perfect however the where &amp was present that was removed and not changed to & (probably due to my poor explanation).

This solution solves that issue as well.

=SUBSTITUTE(SUBSTITUTE((SUBSTITUTE(B8,"&","&")),"&",""),"nbsp;","")

Thank You!