LinkBack URL
About LinkBacks
I would like to be able to remove a string of text in a cell that appears after an '&' symbol in a cell.
I cant use the LEFT or RIGHt function as the '&' Symbol is a different places in each cell.
Any ideas on a method?
Regards BVG
I would like to be able to remove a string of text in a cell that appears after an '&' symbol in a cell.
I cant use the LEFT or RIGHt function as the '&' Symbol is a different places in each cell.
Any ideas on a method?
Regards BVG
Prehaps
=SUBSTITUTE(A1,"&","")
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Try something like:
=LEFT(A1,SEARCH("&",A1)-1)
That works just fine. Thanks for that.
Regards BVG
Last edited by Badvgood; 05-13-2007 at 03:08 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks