How do capture the first three characters from one cell to another cell

  • Thread starter Thread starter ExcelAlex
  • Start date Start date
E

ExcelAlex

"AGC4039" is in cell 1. I want cell 2 to grab the first thre
characters from cell 1 so it will display "AGC"

Anybody know if excel can do this?

Thanks for your help!
Ale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to lookup based in the first 3 characters of a cell 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Formula to validate characters within a string of data in aparticular cell 1
text columns in one cell 13
Excel 2003, Linked Spreadsheet, Cell Character Count 3
How do I get more than 255 characters into a cell? 3
How do I increase viewable cell character count limit in Excel? 2
How to separate contents of one cell into multiple horizontal cell 1

Back
Top