Separating three digits

**skatmandu2002** · 03-19-2010, 07:05 PM

I have a cell that will contain between 2 and 4 characters. The first will always be a letter. The following digits will be a positive integer between 1 and 999.

Let's say that cell is A1. Then in B1, I want the cell to display on the first letter. In cell C1, I want the number to be displayed.

Hope this makes sense, any help as to what formulas to use would be great. Thanks!

**somesoldiers** · 03-19-2010, 07:17 PM

Please see attached- does this work for you?

**dominicb** · 03-19-2010, 07:19 PM

Good evening skatmandu2002

B1 : =LEFT(A1,1)
C1 : =VALUE(RIGHT(A1,LEN(A1)-1))

The VALUE part of the formula ensures that the numeric part is shown as a number. If you would prefer it shown as a text string, just omit the VALUE part, thus : =RIGHT(A1,LEN(A1)-1).

HTH

DominicB