How to delete Column data in Excel without affecting other dependents column

Nikki

New Member
Hi,


How to delete one column data without affecting other dependents columns.View attachment Capture.PNG

here i wrote formula on branch and code. now i want delete "ac no" column without affecting "Branch" & "Code". if i directly delete this column the other two columns showing invalid.
 

VJR

Well-Known Member
Hi Nikki,

For this you will need to at first copy Branch and Code columns and paste them as Values into the next two columns and then delete the AcNo, and previous Branch (with Formula), previous Code (with Formula) columns.
 

Nikki

New Member
Hi VJR,

If i do that its not taking initial 0's of the number. that process ignoring 0's(zero).
 

VJR

Well-Known Member
Hi Nikki,

If you have data in a cell like 023 it will change automatically to 23. It will not show up the zero if the format of that cell is Number but will show up if it is set to Text. So either do manually or if you want to do it dynamically each time then do it through Blue Prism.
 
Top