formaula used to abstract portion of a cell to another cell
 

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.

formaula used to abstract portion of a cell to another cell
 

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

--
HTH

Bob Phillips

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

"cc" wrote in message
...
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.

formaula used to abstract portion of a cell to another cell
 

how can you use the same principle with email addresses?

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"cc" wrote in message
...
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.

formaula used to abstract portion of a cell to another cell
 

Bob,

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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"cc" wrote in message
...
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.

formaula used to abstract portion of a cell to another cell
 

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)

"cc" wrote in message
...
Bob,

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


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"cc" wrote in message
...
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.