formaula used to abstract portion of a cell to another cell

[Guest]

if cell a1 contains text (10-22-198) how do I write a formula that will opy
only a section of the text to another cell. Ex I would like to be able to
take one of the sets of numbers and populate into another cell. But I want
the formula to run through out the column so if cloumn A1 has 10-22-198 then
I could populate B1 with 22 or 10 or 128 and if A2 was a different text the
formular would still populate using B1's informaton into B2.

 

[Bob Phillips]

Look at the LEFT, MID and RIGHT functions in help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

how can you use the same principle with email addresses?

 

[Guest]

Bob,

Do you know how you can use the same principle with email addresses?

 

[Bob Phillips]

Yes, you look for a separator. The obvious one in email addresses is the
domain token, @, so use

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

gives the name

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

gives the domain.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)