D
Doktor1 at Mile High
Is this even possible? I have custom data in cells that contain letters and
numbers that I need to divide by 4 to one column and multiply by 5 into
another column. I need to duplicate it over 12,000 times. Here is an
example:
Primary cell contains 'B-3Y30' where 'B' remains constant and 'Y' equals 48.
Divide cell then reads 'B-43 1/2' and the multiply cell then reads 'B-18Y6'.
The divide cell converts 'Y' to 48 then times 3, adds 30 and divides by 4.
The multiply cell converts 'Y' to 48 then times 3, adds 30, multiplies by 5
and changes the sum to number of "Y's" at 48 with under 48 as the actual
number. Also, the 'B' varies to other letters and sometimes 2 or 3
characters (AXX or RN) and all need to remain constant. I can send an
example of a few if needed. Pretty wild huh? Any help will be appreciated.
numbers that I need to divide by 4 to one column and multiply by 5 into
another column. I need to duplicate it over 12,000 times. Here is an
example:
Primary cell contains 'B-3Y30' where 'B' remains constant and 'Y' equals 48.
Divide cell then reads 'B-43 1/2' and the multiply cell then reads 'B-18Y6'.
The divide cell converts 'Y' to 48 then times 3, adds 30 and divides by 4.
The multiply cell converts 'Y' to 48 then times 3, adds 30, multiplies by 5
and changes the sum to number of "Y's" at 48 with under 48 as the actual
number. Also, the 'B' varies to other letters and sometimes 2 or 3
characters (AXX or RN) and all need to remain constant. I can send an
example of a few if needed. Pretty wild huh? Any help will be appreciated.