deleting part of a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to delete part of the information in a cell automatically. Is
there a formula or a formatting option that will do this.

Example

023311 PP -> want it to be 023311
040421E1 PP -> want it to be 04421E1
 
Looks like you want to eliminate anything after a space
Use this formula
=LEFT(A1,SEARCH(" ",A1))
 
Hi,

Do a find and replace .Find PP and replace it with blank.

Or use the formula

=TRIM(SUBSTITUTE(A1,"PP","")) ( If you want to delete the space before
PP as well)

regards

Govind.
 
Back
Top