Yes, Have a look in the help index for FIND and then for MID and RIGHT.
Combine

--
Don Guillett
SalesAid Software

"Doktor1 at Mile High" wrote
in message ...
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.
--
The Doktor from Mile High