try
=LEFT(G1,FIND(".",G1)-1)

--
Don Guillett
SalesAid Software

"Debbie Nuding" wrote in message
...
I have a spreadsheet that contains text data that I need to
seperate into individual cells.

Is there a way to do this? Here is a sample of the data:

001. Dressage (Pre Training)

I need to seperate the number from text and put them in
their own columns.

Thanks,
Debbie