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!

Other Excel Questions

Excel Tutorials

0

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!

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.