View Single Post
  #4   Report Post  
milano
 
Posts: n/a
Default 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.