SOLVED

Excel formula

New Contributor

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 Replies
best response confirmed by meenu_verma (New Contributor)
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.

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