formula to extract partial content (text) of cell

[milano]

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.

 

[Peo Sjoblom]

=LEFT(cell,6)

look also in help for MID and RIGHT

 

[Elkar]

Assuming "Microsoft" is in cell A1, you could use the formula:

=left(A1,6)

 

[milano]

perfect. Thanks!

Assuming "Microsoft" is in cell A1, you could use the formula:

=left(A1,6)