# Copying only part of a formula from one column into the formula of another.

I'll give the "Why" below, but my question is this: Is there a formula available that will fill in Column 1 with the last numerical digits of Column 2?

**Why:** I am trying to get the total average of a list that contains items that are often duplicated. Column 2 currently shows the sum of the duplicates and I'm trying to give that sum a name using the final title given in its final sequence. (For example, B204-B207 all have the same basic name with a few minor differences, i.e. Libreoffice, LibreOffice, L1breOff1ce, etc.)

Thank you.