(Pete since you were so very wonderful in helping me the last time I thought
maybe you could rack your brain for me on this one) 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


"Pete_UK" wrote:

You're welcome, Maggie - I thought you had lost the thread, but thanks
for feeding back.

Pete

On Nov 14, 6:58 pm, MaggieR wrote:
As usual you are great THANKS PETE!



"Pete_UK" wrote:
Are you clicking on the Setup from within Print Preview? If so, you do
not have access to the Sheet tab to make those changes. Close the
Preview and click on File | Page Setup and then select the Sheet tab.

Hope this helps.

Pete

On Nov 9, 10:30 pm, MaggieR wrote:
I am not sure why but when I creat a new workbook or worksheet it does not
allow me to choose the rows to repeat option in the setup. Is there an area
in the general setup that must be changed to enable this function? Thank you
for your time.- Hide quoted text -

- Show quoted text -