Tags: cell, cells, content, example, excel, extract, formula, microsoft, msdn, partial, software, text

formula to extract partial content (text) of cell

On Microsoft » Microsoft Excel

1,442 words with 3 Comments; publish: Thu, 22 May 2008 20:47:00 GMT; (30677.64, « »)

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.

All Comments

Leave a comment...

  • 3 Comments
    • =LEFT(cell,6)

      look also in help for MID and RIGHT

      Regards,

      Peo Sjoblom

      "milano" <milano.excel.todaysummary.com.discussions.microsoft.com> wrote in message

      news:B7FEDF73-EC55-4F78-BDA3-F2C63B54A2F2.excel.todaysummary.com.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.

      >

      #1; Thu, 22 May 2008 20:48:00 GMT
    • 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.

      >

      #2; Thu, 22 May 2008 20:49:00 GMT
    • 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.

      > >

      #3; Thu, 22 May 2008 20:50:00 GMT