deleting part of a cell

[jenhow]

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

 

[NH]

Looks like you want to eliminate anything after a space
Use this formula
=LEFT(A1,SEARCH(" ",A1))

 

[Govind]

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.