Overriding cell data macro

[Raziel7]

Hi guys,

I look forward to your help.

I need to override cell data. for example, I currently export information from a program to excel. The program info states -22 but i want a macro to change it to Fro.

I also need this for other numbers. I will get something like this:

-22
-22
18
15
1
18

I need them to read

Fro
Fro
Pro
Dry
Chi
Fro

The numbers correspond to a temperate.

Thanks,

Raziel

 

[Tom Urtis]

Maybe there's more to this, but have you tried using the macro recorder with a few Find and Replace methods for what you describe?

 

[Raziel7]

Maybe there's more to this, but have you tried using the macro recorder with a few Find and Replace methods for what you describe?

Hi Tom,

Thanks for your super quick response. I just tried the macro recorder for find and replace and it worked perfectly.

Thank you very much for the suggestions and the your time. Much appreciated.

regards,

Raziel