Extract String

[billandrew]

Good morning

Trying to extract a string of numbers, could be up to 20 values which are separated by a column into individual cells in same row. Formula would be beneficial.

Example

1, 2, 3, - export as 1 2 3 separated.

Thank you

 

[jtakw]

Good.

The Columns function counts the number of columns to provide the multiplier for the starting position of the MID function.
The results from my formula is also converted to a Real number so you can do further calculations with it.
Changing the $B:B in my formula to $AJ:AJ is recommended in case columns gets added before AI.

 

[billandrew]

Thank You very much.

 

[jtakw]

You're welcome.