If you use alt-enter to force that new line in the cell, you could use:

=--LEFT(A1,FIND(CHAR(10),A1)-1)

The =left() portion returns the value as a string. The -- converts that string
to a number.



Ray wrote:

Peo,

Below is an example.

A1 A2 A3
67 78 =A1+A2
Will be discontinued.

"67" and "Will be discontinued." are on two rows of one cell.

Your advice is appreciated.

Ray

"Peo Sjoblom" wrote in message
...
Example?

--

Regards,

Peo Sjoblom

"Ray" wrote in message
...
I have a few columns of cells having a mixed data format of number and
text.
Is it possible to convert the first row of numbers in text data format
for
further calculation? Your guidance to accomplish it is appreciated.

Thanks,

Ray





--

Dave Peterson