Forum Discussion
Is that bUG or FEATURE in excel
I'm a bit surpriced and a bit frustrated
I need to "create text" to external source (actually automatically created tabe into Wikipedia)
data I have in Excel and I tried to create text using Dynamic Arrays - and on requirement - generated text have to contain LF (char(10)) symbol inside. And I really was surpriced - this works weird. Some reason - when You text contains Char(10) or Char(13) - excel (or who else?) add during copy-paste absolutely unwanted "" around line
THere is my example
I select column B and copy paste to notepad:
Only lines containing something like LF or CR surrounded with "
WHY and how to prevent this?
Really long time Excel-user Henn
5 Replies
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 strange
