extracting information from a certain place in one cell

G

Guest

I want to extract a certain alpha numberic phrase within a cell which is
always in the 35th place. I want to extract the N21S8 for all rows in my
spreadsheet.

ie: E300 CB 210X425 STD CEUT E N21S8
 
G

Guest

Will the extracted phrase always be 5 characters in length? If so:

=MID(A1,35,5)

HTH,
Elkar
 
G

Guest

=MID(A1,35,5)

or

=MID(A1,FIND("N21S8",A1,1),5) if postion is variable

or

=RIGHT(A1,5) if it is the last 5 characters in your string
 

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

Extract workbook information 3
How to filter rows data based on background color of individual cells 1
Extract alpha from a cell 1
data from multiple files: best way to extract 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Extracting from a cell 2
extract names based on conditions 2
Extract a number from a variable text string 4

Top