How do I get the first three letters from the front of a cell?
Also is there a method to get the first three and also the last three and put them in a single cell?
I need to do both things but in different parts of excel.
thanks!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
how to get letters from the front of a cell?
0
Answers
0
Selected Answer
You need to use the LEFT() and RIGHT() functions to do this.
These examples assume your data is in cell A1.
To get the first three letters, use this:
=LEFT(A1,3)To get the first three letters and last three letters in the same cell use this:
=LEFT(A1,3) & RIGHT(A1,3)The & sign is what you use to include two functions right next to each other in a cell like this and the process is called "concatenation."
Also, this works for letters, numbers, whatever characters are in the cell.