Need help with extraction of a alphabet from an alphanumeric value

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

Guest

Hi,
I have a column which has values like 00-H15-81366, 03-A02-81570 etc. I need
to make another column which will show the aphabet only e.g. H, A etc. I
would like to know if there is any function that would allow me to do so.
Thanks in advance.
 
If it is always in the fourth position just use...


AlphaField: Mid([SomeFieldName],4,1)
 
Thanks for the help Rick. Regards.

Rick B said:
If it is always in the fourth position just use...


AlphaField: Mid([SomeFieldName],4,1)



Jack said:
Hi,
I have a column which has values like 00-H15-81366, 03-A02-81570 etc. I need
to make another column which will show the aphabet only e.g. H, A etc. I
would like to know if there is any function that would allow me to do so.
Thanks in advance.
Click to expand...
Click to expand...
 
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

Extracting numbers from alphanumeric string 1
Extracting numbers from alphanumeric data 4
SUMIF with alphanumeric criteria range question 3
Extracting 7 digit number from alphanumeric string 10
Copy of just numerical values within strings 1
Removing Text from Alphanumeric values 6
Excel Help to copy information from one row at a time to another sheet 1
Need to flag the lead ID of any contiguous ID's from a sorted list of ID's. 5

Back
Top