LinkBack URL
About LinkBacks
Hi Ashley
try this formula in C2 copied down:
=SUBSTITUTE(SUBSTITUTE(B2,"&",""),"nbsp;","")
Richard
Hi Ashley
try this formula in C2 copied down:
=SUBSTITUTE(SUBSTITUTE(B2,"&",""),"nbsp;","")
Richard
Richard Schollar
Microsoft MVP - Excel
AH! I had never used substitute before.
Your solution is nearly perfect however the where & 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks