Hi Mike,

Can u suggest me how to use this code as I'm not aware of VBA,
and can u please insert one more line in this macro to wrap the cells..That
will be grateful to me..

Excellent reply...

Thanks buddy

"Mike H" wrote:

Hi,

Right click the sheet tab, view code and paste this in.

Sub demergency()
With Selection
.MergeCells = False
.HorizontalAlignment = xlCenter
.EntireColumn.AutoFit
End With
End Sub

Select your range and run the code.

Mike

"Srikanth" wrote:

Hi,

Can any one clarify how to remove merged cells, autofit the data and center
align the contents by having a formula.

Thanks in advance