OK. Post the macro you have, then tell us what you need changed. That will be a
lot quicker than having everyone guess what your spreadsheet looks like.

--
Regards,
Fred


"Dhawal" wrote in message
oups.com...
That Helps. But the data is uncertain so I have temp in many different
columns. There is more data below temp. I need some help with that.

Regards,
Dhawal



Fred Smith wrote:
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...