The easiest way would be to simply record the macro. Start the macro recorder
(ToolsMacros...), then execute the commands you need. Stop the recorder, and
save the macro with whatever name you want.

--
Regards,
Fred


"Dhawal" wrote in message
ups.com...
Hello,

I have a worksheet in which my data is arranged as per temp. I have
Temp in one column and the corresponding value in the other. I need to
inser

For eg.
I have
temp 25C in two adjacent columns

i have to make it Temp: 25C

and remove the 25C from that column.

Can I get some help with the Excel Macro for the same.

Dhawal...