0

I have a column with entries that follow a similar format as the example below: ABC - Adam Smith (T) (ABCadasmi) ABC - John Carter (V) (ABCjohcar)

I'm looking to extract the "ABCadasmi" and "ABCjohcar" strings from these entries. Is there an Excel formula that can do this?

byrak79
  • 61
  • 6
  • 1
    Probably. It should be easy enough to get formulas to extract the strings you are looking for. Will all your data be exactly like the single example you give? – cybernetic.nomad Nov 25 '21 at 18:50
  • Some entries are missing the first (T) or (V) values. – byrak79 Nov 25 '21 at 18:51
  • Have you tried `Find`, looking for `ABC` with a `start_num` of (say) `4`? – Spinner Nov 25 '21 at 19:06
  • Or just look for strings longer than 1 character between `(` and `)` and grab it – cybernetic.nomad Nov 25 '21 at 19:34
  • Try this post https://stackoverflow.com/questions/18617349/excel-last-character-string-match-in-a-string. Or if you don't need to repeat this often, just use Text-To-Columns first and split on delimiter, then enter the '(' as the delimiter. – ACCtionMan Nov 25 '21 at 20:03

0 Answers0