Wednesday, December 30, 2020

Excel: Split Word Into Separate Cells In Excel

 See https://www.extendoffice.com/documents/excel/1697-excel-split-word-into-letters.html


In a blank cell next to your data, C1 for instance, enter this formula:
     =MID($A1, COLUMNS($A$1:A$1), 1)


No comments:

Post a Comment

Creating a LAMP stack on AWS Free Tier

  https://shawn-shi.medium.com/how-to-host-a-lamp-web-application-server-on-aws-ec2-for-free-8f6fc61463ed#:~:text=Its%20free%20tier%20allows...