Copying Data to Excel - Numbers has Paragraph Returns

21

Sublime text also has an Apple version (link prominent on homepage). I use Brackets, is similar but free.

1 Like
22

Iā€™m using windows so ASAP is free in excel go to ASAP and select TEXT so select clean data and formating it clean every thng the numbers come back again

clearing data asap
clearing data asap1920Ɨ1080 178 KB

1 Like
23

it can do many things clearing empty raws and merging it can manage all problems of cut / past from manager it is amazing

24

why trying to do in pc and send the file to mac

25

I use Microsoft 365 on a MacBook Pro.
When I use the standard method of Copy and Paste (so no Paste Special) Excel shows:

knippen_en_plakken_02
knippen_en_plakken_021828Ɨ1686 290 KB

Example is in Dutch language.

So there are no extra characters.

Note that Excel does not recognize the numbers, it is still text to Excel.
So you will have to convert them somehow with the fomulas mentioned in this topic.

When I use the Paste Special method the extra characters show up, like in your example.

26

I think this is an issue specific to RTL languages with LTR numbers.

A typical number in those languages have RTL ā€œdebitā€ and ā€œcreditā€ words followed by LTR number followed by possible LTR or RTL currency symbols.

Thereā€™s a compromise here between having the HTML documents displayed correctly and direct copy and pasting of screen info ā€“ which I donā€™t think is an intended feature of Manager but the option is still there.

I donā€™t really know how the internal mechanics of the translation works, but maybe if the LTR/RTL markers for numbers could be replaced by a <span> tag, maybe this should solve the problem.

I think the developer is the only one who can decide whether this solution practical or not and then he can give the instruction to the translation teams to start wrapping tags around numbers instead of applying direction markers.

I hope that thereā€™s an end solution to this but by the looks of things, it seems like compromises will have to be made any which way.

27

You are correct. Direct copying of a screen display is not a feature of Manager. You can do it for the same reason you can copy text from any browser display.

1 Like
28

A copy to clipboard button in Manager for that screen which copies unformatted data would be a solution consistent with other screens in Manager.

1 Like
29

it is very important
A copy to clipboard button in Manager for that screen that copies data would be a solution consistent with other screens in Manager.

30

Hi everyone,

Thanks for trying to help out!

I did ask an Excel Forum for help as I couldnā€™t identify what the odd character is due to the coding formatting as suggested above.

This formula has been suggested and have worked for me:

=(MID(A1),2,(LEN(A1))

I have added a VALUE function as the above returns Text format and I need it in Number so the new formula is below:

=VALUE(MID(A1),2,(LEN(A1)))

Replace A1 with appropriate cells.

Hope this helps anyone else with this issue. On the positive side I learnt a lot of new stuff trying to figure this out!

But yes a Copy to Clipboard function would be wonderful!