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.
|