Conversion of text string to numbers

[cslayman]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,
I'm trying to convert a text string into numbers in Excel. For example, if the cell has -2,6 in it, I would like to create a cell with -2 and another cell with 6. What string function can I use?

Thanks,
Charlie

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi,
I'm trying to convert a text string into numbers in Excel. For example,
if the cell has -2,6 in it, I would like to create a cell with -2 and
another cell with 6. What string function can I use?

One way:

A1: -2,6
B1: = --LEFT(A1, FIND(",", A1) - 1)
C1: = --MID(A1, FIND(",", A1) + 1, 20)

 

[cslayman]

Hi J E,
That works!

Thanks,
Charlie