extract data up to a certain character

M

markahpi

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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

Bob Phillips

=MID(A1,FIND("/",A1)+1,99)

You can also use Data>Text To Columns with a delimiter of /

--
HTH

Bob Phillips

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