OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT

  • Thread starter Thread starter BIGE
  • Start date Start date
=LEFT(A1,2,1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
 
Forget that one

| =LEFT(A1,2,1)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
|
|
 
OF A 4 DIGIT NUMBER - RETURN THE SECOND CHARACTER FROM LEFT
Click to expand...

I guess the function "LEFT" should help
Assuming the number is in A1,
=LEFT(A1,2,1)

Regards,
S.
 
You must log in or register to reply here.

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

Delete characters from behind if too many 8
Format a result 2
VBA Code for converting Type-E UPC to Type-A (barcodes) 1
Checking if data exists another table and, if yes, extracting a value 0
Macro to re-number data 3
correct syntax for LEFT in vba 3
Userform comobox equal to first 3 digits in a cell 4
SQL - extracing digits from a number 4

Back
Top