Hi there,

Forgive me if this has been asked before - no amount of Googling has led me to the answer!

I have a spreadsheet where each cell is in the format of 2 letters followed by a numerical value, such as:

AK25.75

GN30

BU.25

...

I have to multiply these cells by a certain amount, so in the next column I have, for example:

AK51.50

GN60

BU.50

...

Is there a way to do this such that Excel ignores the text for the purpose of multiplication, but retains it in the next column? (There are 16 possible 2-letter combinations in the entire spreadsheet.)

Furthermore, ideally I need to format any cells with a value greater than or equal to 48 as a factor of 48, where 'Y' is the letter used to signify the number 48. So, for the 2nd column, ideally it would read as follows:

AKY3.50

GNY12

BU.50

If anyone has any ideas, would hugely appreciate a hand with this! If anything's unclear, let me know and I'll try to better explain what I need to do. Many thanks.

## Bookmarks