Avatar of clintnash
Flag for United States of America

asked on 

Formula to Parse numeric text in single field into multiple columns - Excel

I have a field coming from a database that contains a string of data like so:

I need to split this into three different columns but only the numeric value
Col1             Col2            Col3
1                     4                  5
4                     3                  8

I have tried about 10 different approaches and am getting results, just not usable results.

Any advise would be appreciated.
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon