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.

=LEFT(cell,6)

look also in help for MID and RIGHT


--

Regards,

Peo Sjoblom


"milano" <milano@discussions.microsoft.com> wrote in message
news:B7FEDF73-EC55-4F78-BDA3-F2C63B54A2F2@microsoft.com...
> 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.
>

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

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