Replace tool

[BillyL14]

Hi there

Please see my sample data.

I have many rows with values taht are seperated by a comma but all in one cell. Is there a tool I can use to replace the comma with this ";" sign?

Thanks

[JosephSerpis · Accepted solution]

Hi @BillyL14 I mocked up a workflow that produces the output you describe. Let me know what you think?

[Emil_Kos · Accepted solution]

Hi,

You can use the formula tool to do that.

Replace([What I have], ',', ';')

It looks like I am your personal assistant today 😛

[BillyL14]

Hi @JosephSerpis 

looks good, thanks!

[BillyL14]

thanks @Emil_Kos , it does seem like that today haha