Find & and delete everything following

  • Thread starter Thread starter fleura26
  • Start date Start date
F

fleura26

Hi There,
I have a spreadsheet with names in one column, however to load this file I
need to format correctly.
EG column contains:
James Smith & Sarah Brown
I need to delete everything from '&' onwards.
(I have used text to columns using & as the delimiter, however there are
instances of three or four names!)
Is there are delete function I can use? Could you please help?
Thanks in advance!
 
YAYYYY, you just saved me hours of manual work. Thank you thank you thank
you!!!!!!!
 
You may want to search for " &" or add =trim() around that function.

Another possible way is to
Select the column
Edit|replace
what: & (or spacebar ampersand)
with: (leave blank)
replace all

This suffers the same problem if there are varying number of spaces in front of
that ampersand.
 
Without using a formula, you can use find & replace, replacing &* with
nothing (that's ampersand & asterisk)
Bob Umlas
Excel MVP
 
Back
Top