Change the words in the columns

Hi All,

is it possible to have a code or macro that will automatically changed a work in column? For example: if the word in column A:A has the word AE then its shgould be replace by SP. Something like that?

Attached is thue sample file

Hi again can you check the file it seems like it has a problem..

For Sp it has aSP and BP its BPll?

If you automatically want to check/change the entire cell value then try this worksheet event code (put in the respective Sheet module):

Please Login or Register  to view this content.

E.g. if you put in AE in Col.A, the value will be changed to SP.

Hi NeedForExcel,

i still got below Capture.JPG

Hi berlan,

I will have a button that will run the macro. how can i cahnge it?:

I just want that if a cell contains AE it will be SP when i run a formula or macro.

Maybe:

Please Login or Register  to view this content.

Thanks! Exactly what i need!

You're welcome. Glad to help out and thanks for the feedback and the rep.