ExcelBanter - Text and Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Text and Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/210281-text-numbers.html)

Mike

Text and Numbers

My cell contains the data *98. I want another cell to recognize this as the
number 98. Any suggestions ?

Otto Moehrbach[_2_]

Text and Numbers

This formula will work for the example you gave. HTH Otto
=--RIGHT(A1,2)

"Mike" wrote in message
...
My cell contains the data *98. I want another cell to recognize this as
the
number 98. Any suggestions ?

Mike

Text and Numbers

=SUBSTITUTE(A1,"*","")+B1

"Mike" wrote:

My cell contains the data *98. I want another cell to recognize this as the
number 98. Any suggestions ?

Shane Devenshire[_2_]

Text and Numbers

Hi,

LEFT returns text, so instead you can write either

=--RIGHT(A1,2)
or
=--SUBSTITUTE(A1,"*","")

You start both of these with 2 minus signs.

By the way the RIGHT function is set to work only for 3 digit entries, you
could generalize if
=--RIGHT(A1,LEN(A1)-1)

If these help, please click the Yes button.

Cheers,
Shane Devenshire

Mike" wrote:

My cell contains the data *98. I want another cell to recognize this as the
number 98. Any suggestions ?

All times are GMT +1. The time now is 10:31 AM.