Need help to find text before/after specific character in a string

[ArviExcel]

Hi, I've multiple entries in column A, which are Text/Number/Character strings and i've created unique set and placed in a row to search the same text in the Column A and return the value at the end of the string. I know it is difficult to explain, here is what is appear like

Column A
Customer - Interactive -Services -EALA -
Customer - Interactive -Services -APAC -
Digital - Strategy - Operations - Customer -
Digital - Strategy - Operations - Enterprise - 50%; Not Appicable or ABCD 50%;
Digital - Strategy - Operations - Customer - 20%;Digital - Strategy - Operations - Enterprise - 40%;Customer - Interactive -Services -APAC -20%

So, i need to create a model, so that when i paste column A from reports in my model, i should be able to see the allocation % against each of the item. i'm able to get the 1st percentage but unable to create formula to find all formula. Consider i've atleast 25 Strings within the same text in column A.

 

[fabini]

Hi,

You can use "Convert Text to Columns", choose Delimited, and choose the delimiter you want. This way you can gather the formulas easier.

If you really want to keep column A as it is now, here's an example of what you can use:
Cell A1 -> Thomas von Kriken <thomas.von.kriken@yourdomain.com>
Formula to get "thomas.von.kriken@yourdomain.com" -> =MID(LEFT(A1;FIND("@";A1)-1);FIND("<";A1)+1;LEN(A1))

I don't know if it's gonna work on your example since your delimiter is the same for all strings in the same cell, so i would really convert it to columns!

Hope it helps!