Hello,
Is there a text formula I can use to grab specific characters from a source that has varied text format and varied # of characters...Attached is a sample from this source....I need to grab just the numbers at the end of the source entry excluding the zeroes for entries that begins in 0's and excluding the space and dash "-" at the end of each entry. I have along list of this sample that I need to matchup from a different source...I tried doing text to column but the characters I need ended in different columns.
I appreciate any feedback.
Is there a text formula I can use to grab specific characters from a source that has varied text format and varied # of characters...Attached is a sample from this source....I need to grab just the numbers at the end of the source entry excluding the zeroes for entries that begins in 0's and excluding the space and dash "-" at the end of each entry. I have along list of this sample that I need to matchup from a different source...I tried doing text to column but the characters I need ended in different columns.
I appreciate any feedback.