help needed replacing parts of numbers with other numbers

[monkey101]

Hello there

I am a total excel noob. Not sure if this is a Formula or a macro solution so I am going to post in both.

I have column A with numbers like this and there are over 1000 of them
004 0 10 13
004 0 10 14
004 0 10 15
012 0 03 00
012 0 03 01
012 0 03 02
012 0 03 03
I would like to be able change the first set of numbers 004 to 056 and the 012 to 048
Basically i have the following to change
004 to 056
012 to 048
020 to 052
024 to 044
028 to 040

I also need to change the next digit 0 to a 1 if the set of digits is 08 to 15 and then if the third set is 08 to 15 if would need to be changed to
08 to 00
09 to 01
10 to 02
11 to 03
12 to 04
13 to 05
14 to 06
15 to 07


Here are a few examples
004 0 01 01 needs to be changed to 056 0 01 01
004 0 08 12 needs to be changed to 056 1 00 12

Can this all be done with one formula or do I have to do this in stages or can it not even be done? I would like the original number to be in column A and the new number in column B.

Any help would be greatly appreciated.

[AliGW]

This thread is closed as a duplicate. Please do NOT open more than one thread per issue. Have a read through the forum rules before posting again, please.