how to get letters from the front of a cell?

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!

Answer
Discuss

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.

Discuss

Discussion

thanks!
mtone Jun 28, '16 at 9:58 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login