lookup second character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have:
ABC

I want to find the second character only and put it in a different cell.
Example
B


Thanks
 
Ron

In the cell where you want to return "B", enter
=MID(A1,2,1)
where cell A1 contains "ABC"

--


XL2003
Regards

William
(e-mail address removed)
 
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

Vendor Name Lookup 3
Search Formual Error 4
Extracting Data from a string of text in a cell 4
Counting the number of times a character occurs in a cell 1
Extract all text without spaces and special characters 4
Lookup one value, Return matching correspnding values 7
Put parts of cell into separate columns 3
multiple vlookups in one statement 3

Back
Top