Removing part of a String

N

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
 
C

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
 
M

Mazzaropi

NoExcelWizard;1601689 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top