Forum Discussion

HennSarv's avatar
HennSarv
Brass Contributor
Jan 03, 2021

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 Dyna...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 03, 2021

HennSarv 

Not sure what your desired result. Did you apply "Work wrap" formatting to the resulting cells?

HennSarv's avatar
HennSarv
Brass Contributor
Jan 04, 2021

SergeiBaklan 

no difference - formating with wrap or without don't help there

My intention is following

on 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 L

result 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

Henn





 

  

  • HennSarv's avatar
    HennSarv
    Brass Contributor
    Jan 04, 2021

    SergeiBaklan 

     

    Just 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

     

Resources