Can any body help me how to delete cell value in excel, so that remaining row data will be moved to left.
1 sssss 333333 444444 55555
2 c dddddd cvvvvv sssss kkkkk
I need to delete c value in second column so that remaining values will be moved to left side. I didn't get success to find methods in excel API.
is it entire column deletion ?
Certified HP consultant
You mean to delete the column value, if else u need to write custom function with the cell position where you need 2 explicitly set the value to the column on the left!!
Winds of Change