Excel Formula help on multiple data in one field

New Contributor

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 266,004


MV 273,666,570


Thanks for any help on this!

2 Replies


Let'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.

This is what I was looking for exactly! Thank you for the help as this has made my day! Appreciate the help and so quickly. You all are the best.