How to insert particular cell text to another cell conditionally ?

Hi this is nur again ! I have data like below in the cell A2:A & B2:B, color mark tell me which data i need to work with.

Please Login or Register  to view this content.

If you notice carefully here in the cell D2:D I have inserted some extra line & have done concatenate also . however the output results will be something like below in the cell D2:D.please check the attachment..

Please Login or Register  to view this content.

do you need color in the output ?

Try this code in your workbook. It will output the results into Column E. Hope this helps, let me know if there are any issues.

Please Login or Register  to view this content.

Also, I think you have a typo in your example, you have "rxmfo" instead of "rxmfp" in some of your cells.

Hi, AKK9
If you have free time then let me know how it exactly works ? Step by step. It is required for learning . Although I am trying to understand each and every line. Thanks..

Thanks, no problem, glad I could help.

I've never been very good at explaining but I commented my code to try to explain step by step, I hope it helps you:

Please Login or Register  to view this content.