hi all,

I'm having trouble extracting data up on a cell up to a certain
character, for example up to "/"

for example this cell data: David Staton / 102 oak st

I just need "David Station" and leave "/ 102 oak" st alone

thanks for any pointers.
mark


--
markahpi
------------------------------------------------------------------------
markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571
View this thread: http://www.excelforum.com/showthread...hreadid=571997