Yes please, or in column A and B of the existing sheet if that is easier?

"FSt1" wrote:

hi,
would be better. where do you want the results? next sheet?

"JBS" wrote:

Yes, it is a comma delimited file which imports into onecell per row in
Excel. I can change it to be by doing "text to Data"

3010 123456789 4103 123.56 5101 123
3010 987654321 3011 abcde 4103 15000.00 5103 654
3010 654987321 4103 4523.69 5104 987

the result I am looking for would be

123456789 123.56
987654321 15000.00
654987321 4523.69




"FSt1" wrote:

how is this data layed out? All in one cell?
FSt1

"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