Exctract Partial Data from Cell

[gseay]

I am trying to somewhat use a "left" function but the number of characters I am needing to extract will vary. Here is what my data looks like. (Each line is one cell.)

#300 2007 Freightliner
#66471 2008 International
#4540 2009 International

I am needing to separate the unit numbers and description and put into 2 separate cells.

Is there some kind of VBA that will extract all characters until there is a space??? Need some help please!

 

[HalfAce]

Hi and welcome to the board.
I'm a bit confused by your post as both the before & after examples look the same to me. (Well, when they were both there they did...)
Either way though, you should be able to do this using the Text to Columns feature.
(From the menu... Data > Text to Columns > choose Delimited > Next > check the box for 'Space' and hit Finish.)

Does that do what you're after?

 

[gseay]

Thanks! That did the trick!

I had them separated when I was writing the post but when I submitted it the spaces were erased which made it look the same as the top example. So thats why I went ahead and deleted it.

Thank you!

 

[HalfAce]

Most welcome. Glad it helped.