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