P Pinang Member Feb 12, 2024 #1 Hi, Would anyone be able to help me separate column H and copy all data to another sheet? Attached are the data and result sheets for reference. Attachments Text to column and copy data.xlsx 11.1 KB · Views: 3
Hi, Would anyone be able to help me separate column H and copy all data to another sheet? Attached are the data and result sheets for reference.
V vletm Excel Ninja Feb 12, 2024 #2 PinangSomewhere those pre-zeros are needed too... Usage: #1 Modify Data-sheet #2 Select Result-sheet Attachments Text to column and copy data.xlsb 22 KB · Views: 2
PinangSomewhere those pre-zeros are needed too... Usage: #1 Modify Data-sheet #2 Select Result-sheet
p45cal Well-Known Member Feb 13, 2024 #4 Right-click somewhere in the table on the Result sheet and choose Refresh (Power Query query). Attachments Chandoo56132Text to column and copy data.xlsx 20.6 KB · Views: 0