Rows to Repeat at top
 

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.

Rows to Repeat at top
 

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.

Rows to Repeat at top
 

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.

Rows to Repeat at top
 

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 -

Rows to Repeat at top
 

(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 -

Rows to Repeat at top
 

Hi Maggie,

I don't quite understand this - can you give me a bit more background
detail?

Nice to hear from you again.

Pete

On Feb 13, 2:08*pm, MaggieR wrote:
(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 -- Hide quoted text -

- Show quoted text -

Rows to Repeat at top
 

Pete,

In cell B1 is 456P and I would like it to result in A1 P654 the
reverse of what is in B1. We have alpha numeric and numeric characters that
need to be reversed from its original format. We also have 321-21-A in B1 and
need it to come back with A-12-123 in A1. I hope this helps clearing this up.
Someone mentioned a UDF solution but to be honest I am not sure what that is
or how to set it up. So hence the question to the notorious PETE!

"Pete_UK" wrote:

Hi Maggie,

I don't quite understand this - can you give me a bit more background
detail?

Nice to hear from you again.

Pete

On Feb 13, 2:08 pm, MaggieR wrote:
(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 -- Hide quoted text -

- Show quoted text -

Rows to Repeat at top
 

Hi Maggie,

as I still have your email address from before, I've sent you a file with
Gord's UDF already set up in it, so all you need to do is to copy the data
you want to reverse into this file, apply the formula down the adjacent
column, fix the values and then copy back to the original file.

Should be quicker (and more accurate) than manually changing 37,000 entries
!!

Hope this helps.

Pete


"MaggieR" wrote in message
...
Pete,

In cell B1 is 456P and I would like it to result in A1 P654 the
reverse of what is in B1. We have alpha numeric and numeric characters
that
need to be reversed from its original format. We also have 321-21-A in B1
and
need it to come back with A-12-123 in A1. I hope this helps clearing this
up.
Someone mentioned a UDF solution but to be honest I am not sure what that
is
or how to set it up. So hence the question to the notorious PETE!

"Pete_UK" wrote:

Hi Maggie,

I don't quite understand this - can you give me a bit more background
detail?

Nice to hear from you again.

Pete

On Feb 13, 2:08 pm, MaggieR wrote:
(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 -- Hide quoted text -

- Show quoted text -