Mac excel char for new line

broken image

My formula (borrowed from another site) is working fine, except using CHAR(176) returns the infinity symbol instead of the expected degree sign. I'm converting decimal lat/long co-ordinates to a degrees-based format.

broken image

Hi all, got a strange issue that I can't find a solution/explanation for on google and it's driving me crazy. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. You can select code in your VBA window, press Tab, then copy and paste into your post or comment.

broken image

To apply code formatting Use 4 spaces to start each line This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified

broken image

Use the appropriate flair for non-questions.Post titles must be specific to your problem.