| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula to extract partial content (text) of cell
Any suggestions on how to extract partial content from cells? For example,
if a cell's content has "MICROSOFT", I would like to extract "MICROS". Is this possible? Many thanks in advance for your help. |
|
#2
|
|||
|
|||
|
formula to extract partial content (text) of cell
=LEFT(cell,6)
look also in help for MID and RIGHT -- Regards, Peo Sjoblom "milano" wrote in message ... Any suggestions on how to extract partial content from cells? For example, if a cell's content has "MICROSOFT", I would like to extract "MICROS". Is this possible? Many thanks in advance for your help. |
|
#3
|
|||
|
|||
|
formula to extract partial content (text) of cell
Assuming "Microsoft" is in cell A1, you could use the formula:
=left(A1,6) "milano" wrote: Any suggestions on how to extract partial content from cells? For example, if a cell's content has "MICROSOFT", I would like to extract "MICROS". Is this possible? Many thanks in advance for your help. |
|
#4
|
|||
|
|||
|
formula to extract partial content (text) of cell
perfect. Thanks!
"Elkar" wrote: Assuming "Microsoft" is in cell A1, you could use the formula: =left(A1,6) "milano" wrote: Any suggestions on how to extract partial content from cells? For example, if a cell's content has "MICROSOFT", I would like to extract "MICROS". Is this possible? Many thanks in advance for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to extract data from a cell in a formula in another cell | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Linear Mode
