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.

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.

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.

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.