Hi guys
I am looking for the correct code that will allow me to take data from column A, extract the last 5 characters from the cell and add "980" to the start.
So if cell A1 is ZXZXZ83654, I would like cell B1 to be 98083654.
Does this make sense? I was experimenting with...