Removing part of a String

[NoExcelWizard]

Hi All,

Pls suggest a formula to remove only the word "Code" from the list o
strings below:

Zip Code for ABC
Zip Code for XYZ

Thank

 

[Claus Busch]

Hi,

Am Thu, 10 May 2012 07:08:08 +0000 schrieb NoExcelWizard:

Pls suggest a formula to remove only the word "Code" from the list of
strings below:

Zip Code for ABC
Zip Code for XYZ

your string in A1, then try:
=SUBSTITUTE(A1,"Code ",)


Regards
Claus Busch

 

[Mazzaropi]

Hi All,
Pls suggest a formula to remove only the word "Code" from the list o
strings below:
Zip Code for ABC
Zip Code for XYZ
Thanks

<<<<< *HELP from BRAZIL* >>>>>

Dear *NoExcelWizard*, Good Morning.

Suppose your data is on A1.

___A________________B______________
1__Zip Code for ABC___=Formula
1__Zip Code for ABC___Zip for ABC

Do: *B1* --> *=SUBSTITUTE(A1,"Code ",)*

Tell me if it worked for you.

Have a nice day