by Ernie » Sun Jan 05, 2025 9:32 am
Other possible issues:
Quotes can mess things up when there new lines in cells. If you use a double-quote, you need to use them in pairs. Importing using OneDrive or Dropbox would not have this issue.
What also may be going on is they have a tab in one of their cells in Excel? This will be interpreted as a new column and mess things up. This would likely only happen if they are copy-pasting from another source that contains tabs.
You can use a formula to search for tabs if this might be the case.
=SEARCH(CHAR(9),A1)
CHAR(9) is the code for a tab.
Other possible issues:
Quotes can mess things up when there new lines in cells. If you use a double-quote, you need to use them in pairs. Importing using OneDrive or Dropbox would not have this issue.
What also may be going on is they have a tab in one of their cells in Excel? This will be interpreted as a new column and mess things up. This would likely only happen if they are copy-pasting from another source that contains tabs.
You can use a formula to search for tabs if this might be the case.
=SEARCH(CHAR(9),A1)
CHAR(9) is the code for a tab.