extracting after a symbol

[A.S.]

what would be the correct formula to use to extract before or after a
specific character.

For example, if one cell has "Afghanistan=AF". I need to extract everything
before the "=", so that the next cell will just read "Afghanistan". Thanks.

 

[A.S.]

Also need help in extracting after the "=" so that the cell after will ready
"AF". Thanks

 

[Allllen]

=LEFT(A1,FIND("=",A1)-1)

=RIGHT(A1,LEN(A1)-FIND("=",A1))

if your Afghanistan=AF is in cell A1

HTH

 

[T Kirtley]

You can use functions like the following for a text string stored in cell A1:

=LEFT(A1,FIND("=",A1)-1)

=RIGHT(A1,LEN(A1)-FIND("=",A1))

Hope that helps,

TK