Need to add string into particular cell

Hi all,

I have a input with contents in each row like "------ aaaaa", "------ bbbbb", but in some rows i have as "ddddd". What I need is I want to copy those "------" to the cells where is not available. I have attached input. Please help me on this.

Sampe Input.xlsx

Accepted answers

atcodedog05

Hi @Gsiva3

Here is a workflow ??? are removed.

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

parse.yxmd

All comments

Emil_Kos

Hi,

Please find attached. Combination of IF and contains will help in this particular case.

AddString.yxmd

Gsiva3

Thanks for the reply, got it👍. But i have one more constrain. The input also contains

"1234 ------ aaaaa first", "1235 ------ bbbbb second", "1201 ddddd third". So I need to split this cells based on delimeter. For example while splitting the cell "1234 ------ aaaaa first" into columns, I need "1234" in one column and "------" in one column and "aaaaa" in another column and "first" in another column. But since "------" is missing in some cells, I cant split into columns accordingly. Kindly find the attached sample input. Please provide a solution

Sampe Input.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703