| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL HELP
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL HELP
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
EXCEL HELP
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
