I’ve got csv files that are delimited by tabs. Generally, the data is all in the first column but sometimes there’s information in the second and third columns. How can I selectively apply ‘Text to columns’ in excel so that data isn’t overwritten?For example, in the image attached, data sample rows 39, 42, 46-49 etc will be overwritten. I can do a workaround of filtering etc but there must be a quick way of doing this…
You may also like
how do I have put hyperlink inside the translate message? it seems didn’t work…any other option I can do?
I have to make an email template, that is sent when the administrator creates a new account. I made a template, but […]
I got a “It’s almost time to restart” message. How can I avoid the restart? Windows automatic updates are supposed to be […]
The store front shows 500 Internal server error after I followed all instructions in the article here to upgrade Magento. On checking […]