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