Need help to find formula to replace copy and paste when handling massive data

DeeMak123

New Member
Joined
Oct 19, 2019
Messages
2
Hello Guys I need help to copy information from one column to another using an appropriate excel formula. I want to do away using cut and paste methods because am dealing with lots of data hence want to save time. My excel skills are basic but catch up quickly. So a step by step guide will do the trick. thanks guys:)

here is a link to the screen shot https://www.filestofriends.com/share.aspx?code=5ad256a691c84ed6a4f1f44f1c471265
 

ChrisFoster

Board Regular
Joined
Jun 21, 2019
Messages
58
I might be missing the point of what you're trying to achieve, but in K4 put the below formula and the drag it to the rest of the cells you want it transferring to.

Code:
=F4
 

Forum statistics

Threads
1,085,201
Messages
5,382,308
Members
401,781
Latest member
lozzeroooni

Some videos you may like

This Week's Hot Topics

Top