Offset Function Help

[Guzzlr]

Hello All...
In cell D13, I have: "224 Robbins & Painted Bunting"

I wish to separate the statement of: "Robbins & Painted Bunting" in cell D14, and keep the number 224 by itself in D13.

Is this possible with the Offset function?

Thanks for the help
excel 2013

 

[oldbrewer]

in d14 put =left(d13,3)

in d15 put =mid(d13,5,999)

 

[Guzzlr]

in d14 put =left(d13,3)

in d15 put =mid(d13,5,999)

That was the ticket...Thank you, it worked nicely!

 

[Guzzlr]

in d14 put =left(d13,3)

What if, the number of "224" is instead a single digit, or the next row of 5 digits. How would I have the left formula to pick up the digits, regardless of the number length?
Thanks

 

[Fluff]

Try
=LEFT(D13,FIND(" ",D13)-1)
=MID(D13,FIND(" ",D13)+1,999)

 

[oldbrewer]

Happy New Year - Fluff

 

[Fluff]

And to you

 

[Guzzlr]

Try
=LEFT(D13,FIND(" ",D13)-1)
=MID(D13,FIND(" ",D13)+1,999)

Very Nice...Thank you

 

[Fluff]

You're welcome

 

[Rick Rothstein]

Try
=LEFT(D13,FIND(" ",D13)-1)
=MID(D13,FIND(" ",D13)+1,999)

That second (highlighted) formula could also be replaced (no pun intended) with this one...

=REPLACE(D13,1,FIND(" ",D13),"")