Try this in B1 and drag down.

=MID(A1,FIND(4103,A1,1)+5,(FIND(",",A1,FIND(4103,A 1,1)+5))-(FIND(4103,A1,1)+5))

Mike

"JBS" wrote:

I have a file as follows
3010,123456789,4103,123.56,5101,123
3010,987654321,3011,abcde,4103,15000.00,5103,654
3010,654987321,4103,4523.69,5104,987

I need to search for the value 4103 and return the value after it eg. 123.56