How do I extract a letter from a group of numbers and put in into a different cell. For example: Cell B6 has A123456 and I want the letter A taken and put into cell A6 and leave the rest of the number in B, if B doesnt have a letter in it, then leave the A cell blank and color it yellow.
Thanks
Thanks