YAYYYY, you just saved me hours of manual work. Thank you thank you thank
you!!!!!!!
"Ashish Mathur" wrote:
Hi,
Try this
=LEFT(EG3,SEARCH("&",EG3,1)-2)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"fleura26" wrote in message
...
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!