Hello Everyone,
I have a column with 3 digit numbers (A), then I have 3 columns where I pull each of the 3 digit number to show single digits in Columns (B, C, D)
Next in column "E" I pull the 1st and 2nd digit from the 3 digit numbers in column A and put them together.
Column F is my problem, I will explain after I explain Column G.
Column "G" I pull the 2nd and 3rd digit from the 3 digit numbers in Column A and put them together.
I have both E and G columns working with the formula Im using
Now for Column F i want to pull the 1st digit and the 3rd digit from the 3 digit number to put in column F together just like columns E and G.
I can't figure out how to pull the 1st digit and 3rd digit and leave 2nd digit alone for this Column F.
BTW, these numbers will continue over time and I will need to just drag down the column to update future 3 digit numbers
Thanks,
Brian
Bookmarks