extract text from string

A

AskExcel

hi,
i have string as below. i need to extract 4 letter after the ','. the 4
letter is ABCD,AEGR,RTYT and TYRE.
may i know how to extract?
thanks

d123,00ABCD9657
d1005,12AEGR8678
d23,23RTYT6545
w345676,23TYRE7786
 

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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Extract embedded excel file from word document 0
Insert name and adress from a list in a word document 1
Extracting the last word from a string. 2
inlineShape.OLEFormat.Activate() command fails for excel file 0
Page sort 0
Transfer data between two tables 3
List all tables, including document structure 0

Top