Forum Discussion
Is that bUG or FEATURE in excel
Not sure what your desired result. Did you apply "Work wrap" formatting to the resulting cells?
SergeiBaklan
no difference - formating with wrap or without don't help there
My intention is followingon col-s A:F is 'unsorted' list of people to be generated as alphabetically sorted list for Wikipedia
using following formulas (might be better idea)
col I =UNIQUE(LEFT(INDEX(A2#;;4);1))
col J ="=="&UNIQUE(LEFT(INDEX(A2#;;4);1))&"=="&CHAR(13)&CHAR(10)&"{{tähed}}"
col Lresult must contain ORDERED list of names inserted with
==X==
{{tähed}}
for each letter
==X== produces heading style row in wikipedia
{{letters}} produces linkable letter-index
I have 3 ways to producse this result
* old-style excel functions (yes sorting was available with old excel functions)
* PowerQuery cenerating desired result
* Dynamic Array - as above
My concern is - WHY cells containing LF or CR during copy-paste generation unwanted "" around
result is that I have during copypaste land in "notepad", Ctrl-H remove "-s and after that copypaste to wikipedia source
HennJust tested - looks like some kind of hardcoded feature in excel
ANY cell containing LF of CR (normally ALT-ENTER) will produce "" around during copy-paste into other application (form)
VERY strangeYes, I forgot about this issue. Here is quite old discussion formatting - How to copy multi-line text from Excel without quotes? - Super User , there are few more, but I didn't see proper solution.
