Hello,
I have a cell with 8 digits in it. I am using the "right" function to extract the last 2 digits into another cell. Then I need to add the letters CC on the front of the digits.
Example:
Cell A1 564356-02
Cell B1 CC02
After the formula cell A1 will be 564356.
I have a cell with 8 digits in it. I am using the "right" function to extract the last 2 digits into another cell. Then I need to add the letters CC on the front of the digits.
Example:
Cell A1 564356-02
Cell B1 CC02
After the formula cell A1 will be 564356.