Forum Discussion

Copper Contributor

Oct 18, 2023

Excel treatment of Char(11)

I'm hoping this is not off topic for this forum, but I really don't know where else to go. I have for several years used a way of 'generating' a risk register in Excel by dumping data into a simple...

MVP

Oct 18, 2023

I think https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral could be a better place to ask this question.

DavidwinterPHC
Copper Contributor
Oct 19, 2023
Harm_Veenstra
Thanks Harm, but since finding the answer in consultation with a Microsoft tech support person, the question morphs into one of typical Microsoft disregard for it's customer base. So, back to appropriate for this forum, I think.
In moving from a very old laptop (Core i3) running Windows 10 and on to a laptop running Windows 11 it seems that Microsoft kindly upgraded its Notepad.exe to a lovely new version that interprets the Char(11) character as a Carriage Return (Char(13)). The solution was to turn this gift off and revert to the classic Notepad.exe.
Thank you Microsoft for causing me a whole **bleep** morning of dedication the work around for this 'upgrade'. If Microsoft developers actually used their operating system in a real world environment outside of their ivory tower with perfect internet access and unlimited time for laptop management, they might see the inadequacy of their product(s).

Resources