SOLVED

New Contributor

Excel formula

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

Re: Excel formula

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.

Re: Excel formula

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