=LEFT(A1,FIND("/",A1)-1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"markahpi" wrote in
message ...

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