Forum Discussion

Catherine Petty's avatar
Catherine Petty
Copper Contributor
Oct 31, 2018

Extract a string of variable length and position from a cell

Hi Please could you advise the easiest way to extract a serial number consisting of two letters and four numbers (CM****) from a string of text.  Unfortunately the position of the serial number is n...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 31, 2018

Hi Catherine,

 

Please try this formula in cell H6 and drag it down:

=MID(C6,SEARCH(" CM",C6)+1,6)

 

The SEARCH function will find the right position to start from.

 

Hope that helps

Resources