You may have extra options when pasting into Excel. So don’t remove or replace the tabs unless there are some that are creating columns you don’t want. When pasting data into a spreadsheet program like Excel, it usually converts tab spaces into column breaks. Tabs are commonly used as column separators.But for the basic operations you should be able to use that instead of downloading new software like Sublime Text.

I haven’t used Mac OS in several years, so I can’t remember what it’s called or what functionality it has.

Mac OS comes with its own text editor.

Please let me know if this issue can be fixed or if you need more information. They all return the same result.Īttached are images of the original sales order page and the result on Excel under qty and original price it’s showing this symbol and columns beside of the right using these referenc numbers are not recognising them as numbers. I have tried pasting on Google sheet as well as on Microsoft Excel on Windows as well. 61 (Official Build) (x86_64) with Macbook Air 2020 and Microsoft Excel for Mac version 16.53. I am using the Cloud version of Manager 21.10.19 on Google Chrome Version.

Which gets very difficult with large amount of data.

We have tried using the Excel replace function with no luck and can only manually delete the return by pressing delete 3x times before the numbers. The spreadsheet now no longer recognise these as numbers even though it’s showing fine and therefore formulas cannot be used. There is a symbol in front of the numbers, an arrow up which turn right. We have been doing this for years but only recently (Maybe around 3 months-ish that we keep noticing Paragraph Returns (At least we think it might be a Return) on two columns of numbers (quantity and unit price) when pasting onto Excel Sheets. I have an issue with copying data from my Sales order page to Excel.

Excel 16.53