Topsy

MS Excel LEFT, MID, RIGHT Functions: How To Slice Up Cell Contents

Why would anybody want to automate slicing up cell contents in a spreadsheet? If you ever tried to copy a list from a web page or from a .txt file and paste it into Excel with the purpose of creating a database, then you know how frustrating it is to go through cells and edit them one by one. I’ll give you the first example that pops into my mind: you have a list of people, you have the name,... moreWhy would anybody want to automate slicing up cell contents in a spreadsheet? If you ever tried to copy a list from a web page or from a .txt file and paste it into Excel with the purpose of creating a database, then you know how frustrating it is to go through cells and edit them one by one. I’ll give you the first example that pops into my mind: you have a list of people, you have the name, surname and age of each person in a single cell, but you need to put them in a separate cells, in order to be able to order your table by surname or by age. view page