extract data up to a certain character

[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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[markahpi]

forgot asking on how to extract the other part "102 oak st"
only?

 

[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)

 

[markahpi]

thanks bob!

 

[Dave Peterson]

You have more responses at your other post.

forgot asking on how to extract the other part "102 oak st"
only?