Need to get same length series of numbers from different columns in the same cell

[tudorr]

Hello. Anyone with an idea to solve this task with a formula or a macro?

I have this strange number data stored by columns. Each cell contains one number series of different length from 1 to 13.

Needed results 1 , Needed results 2
7409998765 7409998766 , 9998766567876 7409998765 9998766 9998766 7409998766 9998766 9998766567876 9998766 9998766 9998766

I need to lookup and bring in one cell for each row only the 10 length numbers separated by space and in another cell the 13 length numbers space separated also.

The number of columns containing data is different from row to row ( from 2 to 60)....and the rows..are thousands..

See attach of example data.

Thank you for any idea.

Tudor

[FDibbins]

sorry, i dont understand what you want. please show a sample of what you have, what you want, and how you arrived that that

[tudorr]

sorry, i dont understand what you want. please show a sample of what you have, what you want, and how you arrived that that

An example file is attached...

I have multiple rows and different columns with different length number data ( variable from 2 columns to 60). This number data length is variable from 2 digits to 13 digits. I need a formula to identify extract for each row, in one column the 10 length data and in another column to 13 length data, as shown in my attached example..


Thanks

[FDibbins]

yes i saw your example, but still dont understand. anyway, try left() mid() and right() functions