extracting information from a certain place in one cell
 

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

extracting information from a certain place in one cell
 

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

=MID(A1,35,5)

HTH,
Elkar


"Wooddy" wrote:

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

extracting information from a certain place in one cell
 

=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


"Wooddy" wrote:

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