Thank you very much guys, you've been very helpful as usal,.

Thanks,
Lime

"Richard Buttrey" wrote:

On Thu, 13 Oct 2005 11:39:06 -0700, "Lime"
wrote:

Hello,
I have a formula/function question. Say I have a cell, For this question
I'll Call it Cell A1 and in that cell the is a list of product numbers
312.00/ 541.0, 541-100\ the only common separator is a space between each
number, and the numbers range between 4 and seven digits. Is the a formula of
function that would separate the product number into three different columns?

Thanks,
Lime

The following splits the 23 character A1 cell into 8, 7 & 8 characters
in B1:D1.


B1 = =LEFT(A1,FIND(" ",A1))

C1= =LEFT(RIGHT(A1,LEN(A1)-FIND(" ",A1)),FIND("
",RIGHT(A1,LEN(A1)-FIND(" ",A1))))

D1= =RIGHT(A1,LEN(A1)-FIND(" ",A1,LEN(B1)+LEN(C1)))

This includes the comma in the middle which you may want to avoid. In
which case change C1 to:
=LEFT(RIGHT(A1,LEN(A1)-FIND(" ",A1)),FIND(" ",RIGHT(A1,LEN(A1)-FIND("
",A1)-2)))

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________