Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |