Suggest using Left and Right Formulas

Martin
-----Original Message-----
Jmbostock,

Have you considered to use : Data / Text to Columns...

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Jmbostock" wrote
in message
...
I have an excel spreadsheet created from an external
database program.
Unfortunatly it didn't format the cells or split the
text into
different columns.

An example of which is :

000105 Ritz Camera Center

This is all in one cell.

What i'm trying to do is split the cell in 2, having
the Vendor Code in
one cell (000105) and the vendor name in the other.

Ideally i'd like to have a macro split the cell at the
first blank
space, but i'm at a loss on how to do that. If anyone
has an idea of
how i can do this i'd really appreciate the help. Been
hitting my head
against a wall on this one.

James


---
Message posted from http://www.ExcelForum.com/



.