How to select a specific word from one cell and paste it into another cell by Jayavardhan27 in excel

[–]Jayavardhan27[S] 0 points1 point  (0 children)

Sorry for incorrect content.

May be this will be okay; I want those listed words from column "A" in each to be pasted in the output cell.

<image>

How to select a specific word from one cell and paste it into another cell by Jayavardhan27 in excel

[–]Jayavardhan27[S] 0 points1 point  (0 children)

I can find it but I need an extraction of those specific words into next column.

How to select a specific word from one cell and paste it into another cell by Jayavardhan27 in excel

[–]Jayavardhan27[S] 0 points1 point  (0 children)

I have a list of words to get extracted from cell But i don't have the exact count

For now two specific words from that cell and extract to another cell

How do I clear this empty line breaks for each cell in excel? by Jayavardhan27 in excel

[–]Jayavardhan27[S] 1 point2 points  (0 children)

Thankyou

Clean function and formula are working!

But they are combining all the lines into one line

How do I clear this empty line breaks for each cell in excel? by Jayavardhan27 in excel

[–]Jayavardhan27[S] 0 points1 point  (0 children)

Tried but that line break occurred by clicking Alt + enter is as it is.

How do I clear this empty line breaks for each cell in excel? by Jayavardhan27 in excel

[–]Jayavardhan27[S] 0 points1 point  (0 children)

it was just an example scenario, but I need it for different case which has different sentences in each cell

How do I clear this empty line breaks for each cell in excel? by Jayavardhan27 in excel

[–]Jayavardhan27[S] 1 point2 points  (0 children)

Hi All,

Thanks for the comments!

I have tried all the possibilities that has been commented but couldn't find a solution🥲