Excel MATCH Query - Help please 1

[Bill4tektips]

I have been given an Excel spreadsheet that contains thousands of entries. In one column there is a load of text that contains a Serial No. I need to extract the Serial No. to Column A. The Serial No. is always in the same place within the Cell (#15:#21). Does anyone know how to do this?

 

[SkipVought]

Hi,

If i understand you correctly, you can use the MID() function...
[tt]
=MID(A2,15,7)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Bill4tektips]

Thanks Skip, works a treat.