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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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" <[email protected]> wrote in
message news:[email protected]...
>
> forgot asking on how to extract the other part "102 oak st"
> only?
>
>
> --
> markahpi
> ------------------------------------------------------------------------
> markahpi's Profile:
http://www.excelforum.com/member.php...o&userid=37571
> View this thread: http://www.excelforum.com/showthread...hreadid=571997
>

[markahpi]

thanks bob!

[Dave Peterson]

You have more responses at your other post.

markahpi wrote:
>
> forgot asking on how to extract the other part "102 oak st"
> only?
>
> --
> markahpi
> ------------------------------------------------------------------------
> markahpi's Profile: http://www.excelforum.com/member.php...o&userid=37571
> View this thread: http://www.excelforum.com/showthread...hreadid=571997

--

Dave Peterson