extracting after a symbol
 

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.

extracting after a symbol
 

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

"A.S." wrote:

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.

extracting after a symbol
 

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

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

if your Afghanistan=AF is in cell A1

HTH
--
Allllen


"A.S." wrote:

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

"A.S." wrote:

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.

extracting after a symbol
 

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

"A.S." wrote:

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

"A.S." wrote:

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.