Extract first 10 digit if preceding semicolon is >10 digit

I'm a bit confused... your Output isn't consistent with your sample.

Let me see if I understand this...

First you extract out list of numbers separated by semicolon, which has more than 10 digits.
From that result, you want first 10 digit before semicolon... meaning 10 digits preceding semicolon.

Non of your example match first condition of Len(value) > 10. Longest digit only has 10 digit.
Did you mean 10 or more digits?

Also, should the result include last value after semicolon if it meets condition (i.e. value preceding line termination)?

As well, how should the result be returned? As array? String?

I'd recommend uploading sample workbook with few samples and manually created expected output.

To upload file, use "Go Advanced" button, and find and click "Manage Attachments" hyperlink. This will launch new tab/window for managing uploads.

Cross-posted here: https://www.ozgrid.com/forum/forum/h...limit-by-comma

Please be aware that our forum rules require you to tell us where else you have asked the same question. I have done this for you this time - if you cross-post again, you MUST do it for yourself. Thanks.

I would use a user defined function for that.

However you example does not make sense.



Place this code in to a Macro Module.

Please Login or Register  to view this content.

Then this formula in any cell will extract your data from cell A1

=MyExtract(A1) will return 3214124141, 1217369889 this is not 1232141241 & 121736988 as you requested.