Stories
Slash Boxes
Comments

SoylentNews is people

posted by martyb on Monday November 26 2018, @02:32PM   Printer-friendly
from the putting-it-all-together dept.

If you've ever tried to use the CONCATENATE function in Microsoft Excel to merge the values in a range of cells, you know it doesn't work unless you add each cell to the function, one by one.

You might have noticed the following message in the support article for CONCATENATE:

Important: In Excel 2016, Excel Mobile, and Excel Online, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.

Meet the alternatives: CONCAT and TEXTJOIN

for CONCAT and TEXTJOIN:

Note: This feature is not available in Excel 2016 unless you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

While it is admirable that Microsoft is finally fixing some of the idiosyncrasies of its software, I fear the future will bring a level of fragmentation unseen since the office 2003 to 2007 switch.


Original Submission

 
This discussion has been archived. No new comments can be posted.
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 5, Informative) by Runaway1956 on Monday November 26 2018, @07:30PM

    by Runaway1956 (2926) Subscriber Badge on Monday November 26 2018, @07:30PM (#766561) Homepage Journal

    In the corporate world . . . too much time invested

    It's not the corporate world that paid all that time. This is one of the things that really burn me up about Microsoft, governments, and education. For longer than my sons have been alive, the schools have been teaching stuff that they call "computer science". In actuality, they were busy building that Microsoft capture. Every kid who has graduated high school in the past 30 years of so has been at least moderately competent on Microsoft products - but they know Jack-shit about anything else.

    Of course most corporations can't afford to correct a shit education. They are now stuck with inferior students from an inferior education system who only know how to us Microsoft Excel. Interestingly enough, those students really believe that a MS spreadsheet is the solution to EVERYTHING !!

    --
    "no more than 8 bullets in a round" - Joe Biden
    Starting Score:    1  point
    Moderation   +3  
       Informative=3, Total=3
    Extra 'Informative' Modifier   0  
    Karma-Bonus Modifier   +1  

    Total Score:   5