So I clicked “Batch Update” and “Copy to clipboard” to paste some data in the spreadsheet and make fixes and all data is copied into a single column in the excel sheet instead of being separated by columns. How to fix this? I am using latest excel and Windows 10
It is most likely Excel spread sheet setting.
Go to “Text to Columns” in Excel and ensure the “tab” delimiter is selected.
when you Paste the data don’t double-click on the cell before Pasting. just select the cell and hit Ctrl + V
Many similar problems have been discussed over the years on the forum. They all turn out to be spreadsheet behavior depending on spreadsheet version and even region. Solutions have varied. Search the forum for these discussions.