Pick the required text from cell

[Salamullah]

Hi Experts,

I want to get specific text from the Column A to B like follows, please help with formula

[TABLE="width: 500"]
<tbody>[TR]
[TD]SPVAR JAN 19[/TD]
[TD]SPVAR[/TD]
[/TR]
[TR]
[TD]IFG JAN 19[/TD]
[TD]IFG[/TD]
[/TR]
[TR]
[TD]R1 Adjustment JAN 19[/TD]
[TD]R1 Adjustment[/TD]
[/TR]
[TR]
[TD]Stock Adjustment JAN 19[/TD]
[TD]Stock Adjustment[/TD]
[/TR]
[TR]
[TD]IFG FEB 19[/TD]
[TD]IFG[/TD]
[/TR]
[TR]
[TD]SPVAR FEB 19[/TD]
[TD]SPVAR[/TD]
[/TR]
[TR]
[TD]Stock Adjustment FEB 19
[/TD]
[TD]Stock Adjustment[/TD]
[/TR]
[TR]
[TD]IFG MAR 19[/TD]
[TD]IFG[/TD]
[/TR]
</tbody>[/TABLE]

 

[Salamullah]

Re: Pick the requierd text from cell

Now additional requirement comes,

In column A some lines are appearing with vendor name but in column B IFG, SPVR & R1 Adjustment is appearing I am sure there is a way to add this in same formula, means formula to read from column A & B to pick IFG, SPVR & R1 Adjustment.

 

[Sanjeev1976]

Re: Pick the requierd text from cell

Please provide some sample data with desired results