Nov 01 2021 01:06 PM
Hi all,
I was wondering if I could get some help in resolving an issue I am seeming not to figure out. I have the below data set and trying to get it separated into three distinct columns. The first data set is standard, the second data set can range in value and the third data set can be present but not always.
MV 275,897 CODE P
MV 5,889,225
MV 151,500
MV 26,554
MV 83,021
MV 555,726
MV 532,308
MV 516 CODE T
MV 266,004
MV 273,666,570
Thanks for any help on this!
Nov 01 2021 01:17 PM
SolutionLet's say the data start in A2.
In B2:
=IFERROR(LEFT(A2,FIND(" ",A2)-1),"")
In C2:
=IFERROR(MID(A2,FIND(" ",A2)+1,IFERROR(FIND(" ",A2,FIND(" ",A2)+1),100)-FIND(" ",A2)-1),"")
In D2:
=IFERROR(MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,100),"")
Fill down.
Nov 01 2021 01:28 PM
Nov 01 2021 01:17 PM
SolutionLet's say the data start in A2.
In B2:
=IFERROR(LEFT(A2,FIND(" ",A2)-1),"")
In C2:
=IFERROR(MID(A2,FIND(" ",A2)+1,IFERROR(FIND(" ",A2,FIND(" ",A2)+1),100)-FIND(" ",A2)-1),"")
In D2:
=IFERROR(MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,100),"")
Fill down.