Extract data in excel between a string

Do you want this data all in one column?

=LEFT(C3,FIND(" ",C3)-1)

=MID(C3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C3&"0123456789")),FIND("(",C3)-1-MIN(FIND({0,1,2,3,4,5,6,7,8,9},C3&"0123456789")))

=MID(C3,FIND("(",C3)+1,FIND(")",C3)-FIND("(",C3)-1)

=MID(C3,FIND(")",C3)+3,LEN(C3)-3-FIND(")",C3))


paste these in order and this is based if your information is in C3 if you need to see them in action here you go split numbers.xlsx


if you think this helped let me know. this took a while to figure out


EDIT I added a minus 1 to this formula because it was dragging a space after 9999

With one formula

in B1 and pull formula to the right until you see blanks

=TRIM(MID(SUBSTITUTE(" "&SUBSTITUTE(SUBSTITUTE($A1,"(",""),")","")," ",REPT(" ",125)),125*COLUMNS($A:A),125))

Row\Col	A	B	C	D	E
1	ABCD 9999 (4200) (25)	ABCD	9999	4200	25

You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).