Hello i have a little problem here. , how can i fill colomn B faster.
problem - > https://i.imgur.com/X7qf5vs.jpg
ERJXGNJ7R8Y - where the R in 7R8Y stands for a decimal = 7.8
ERJXGNJ753Y * where the 3 in 753Y is the decimal place = 75000.0
video here - > https://streamable.com/4ssy1