How can I adjust the content in excel?

[karankmr189874]

Hello,
I need help from you guys. I have a excel file. In the file, in few columns, data star from column d and, in few coulumns it start from column E. But all the data should be started from column D. I have more than 100 files. If I manually make changes in all the files, it will make more than 7 days.

Is there any formula to adjust the content?

Snapshot:-

https://imgur.com/wr6b3D2

 

[karankmr189874]

Thanks.
It has been solved. I found the solution.



Thanks again

 

[pecoflyer]

Cross post
https://www.mrexcel.com/board/threads/how-can-i-adjust-the-content-in-excel.1234100/
and

How can I adjust the content in excel?

Hello, I need help from you guys. I have a excel file. In the file, in few columns, data star from column d and, in few coulumns it start from column E. But all the data should be started from column D. I have more than 100 files. If I manually make changes in all the files, it will make more...

www.excelforum.com

and

How can I move cells ? - VBA - OzGrid Free Excel/VBA Help Forum

Hello, I need help from you guys. I have a excel file. In the file, in few columns, data star from column d and, in few coulumns it start from column E. But all the data should be started from column D. I have more than 100 files. If I manually make…

forum.ozgrid.com

 

[vletm]

karankmr189874
#1 open file
#2 if data starts from E-column then delete A-column manually
#3 if there are more files then continue from step #1

Please, reread and follow Forum Rules - those are for You too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Please post, new posts in the correct forums
  • You've opened Ask an Excel Question ... and did You accept VBA Macros-solution?
• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

 

[pecoflyer]

Also cross posted at https://forums.excelguru.ca/threads/how-can-i-adjust-the-content-in-excel.11715/#post-48565