I have the numbers 123 in A1 and would like to know if there is a formula
that will reverce the information in A1 and in B1 give a result of 321. Thank
you

Can you make do with a UDF?

Public Function RevStr(rng As Range)
RevStr = StrReverse(rng.text)
End Function

=revstr(cellref)

If you want to use the 321 as a number

=revstr(cellref) * 1


Gord Dibben MS Excel MVP


On Tue, 12 Feb 2008 12:55:02 -0800, MaggieR
wrote:

I have the numbers 123 in A1 and would like to know if there is a formula
that will reverce the information in A1 and in B1 give a result of 321. Thank
you

What is a UDF?

When I type in =revstr(B1) or =revstr(B1)*1 they both come back with NAME?

Did I do something Wrong?

"Gord Dibben" wrote:

Can you make do with a UDF?

Public Function RevStr(rng As Range)
RevStr = StrReverse(rng.text)
End Function

=revstr(cellref)

If you want to use the 321 as a number

=revstr(cellref) * 1


Gord Dibben MS Excel MVP


On Tue, 12 Feb 2008 12:55:02 -0800, MaggieR
wrote:

I have the numbers 123 in A1 and would like to know if there is a formula
that will reverce the information in A1 and in B1 give a result of 321. Thank
you

It won't work, it is based upon a multiplication technique, and you cannot
multiply text.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"MaggieR" wrote in message
...
bob, that worked on the numeric cells(THANK YOU) but what would I do if
they
were numeric and alpha numeric in the same cell?

"Bob Phillips" wrote:

=SUMPRODUCT((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1) )*(10^(ROW(INDIRECT("1:"&LEN(A1)))-1)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"MaggieR" wrote in message
...
I have the numbers 123 in A1 and would like to know if there is a
formula
that will reverce the information in A1 and in B1 give a result of 321.
Thank
you

Bob is there a different technique that could be used rather than a
multiplication to get a numberic/alpha numeric out come? Since most of the
data needing to be converted is both alpha and numeric we are having to hand
change 37K entries. THank you for your previous help by the way!!!!!!!!!!!!

"Bob Phillips" wrote:

It won't work, it is based upon a multiplication technique, and you cannot
multiply text.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"MaggieR" wrote in message
...
bob, that worked on the numeric cells(THANK YOU) but what would I do if
they
were numeric and alpha numeric in the same cell?

"Bob Phillips" wrote:

=SUMPRODUCT((MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1) )*(10^(ROW(INDIRECT("1:"&LEN(A1)))-1)))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"MaggieR" wrote in message
...
I have the numbers 123 in A1 and would like to know if there is a
formula
that will reverce the information in A1 and in B1 give a result of 321.
Thank
you

On Wed, 13 Feb 2008 05:58:01 -0800, MaggieR
wrote:

Bob is there a different technique that could be used rather than a
multiplication to get a numberic/alpha numeric out come? Since most of the
data needing to be converted is both alpha and numeric we are having to hand
change 37K entries. THank you for your previous help by the way!!!!!!!!!!!!

Use Gord's UDF solution!
--ron