Excel formula

[meenu_verma]

can anyone help me to get the data from Column "A" as per the column "G"
What formula should i use there

		Expected output for Problem 1
Instrument Name		Security/Issuer Name
A BC		A BC
A BC AUG 21 210C		A BC
A BC OCT 21 150C		A BC
A BC OCT 21 160P		A BC
D E		D E
D E AUG 21 10C		D E
D E AUG 21 7.5C		D E
D E NOV 21 10C		D E
M		M
M DEC 21 2.5C		M
ST DEC 21 72.51C		ST
ST DEC 21 77.51C		ST
ST DEC 21 84.99C		ST
DG		DG
DG JAN 23 22.5P		DG
RG AB		RG AB
RG AB JAN 23 20C		RG AB
RG AB JAN 23 30C		RG AB
T RE JAN 23 50P		T RE
T RE MAR 22 60C		T RE
RS DEC 21 72.5C		RS
RS JAN 22 50P		RS
RS JAN 22 57.5C		RS
RS OCT 21 65P		RS
RS OCT 21 70C		RS
BR DEC 21 19C		BR
BR JAN 22 19C		BR
BR JAN 22 20C		BR
BR MAY 22 19C		BR
BR NOV 21 18C		BR
FT JAN 22 77C		FT
FT NOV 21 72.5C		FT
FT OCT 21 78.15C		FT
Y WEEKLY 10/01/21W 185C		Y

[#2 · Accepted solution]

@meenu_verma 

It would have been nice if you had told us the "rule" behind this, instead of letting us figure it out (perhaps incorrectly).

In G3:

=LEFT(A3,IF(IFERROR(FIND(" ",A3,IFERROR(FIND(" ",A3),0)+1),LEN(A3)+1)-IFERROR(FIND(" ",A3),0)<=3,IFERROR(FIND(" ",A3,IFERROR(FIND(" ",A3),0)+1),LEN(A3)+1),IFERROR(FIND(" ",A3),0))-1)

Fill down.

[#3]

Thank you so much Hans
Actually, first time i used that community so didn't explain much about the rules!
I was actually curious to connect with some one who can directly guide me