Replace tool

Question

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

replace , with ;.xlsx

JosephSerpis · Accepted Answer

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

Emil_Kos · Accepted Answer

Hi,

You can use the formula tool to do that.

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

It looks like I am your personal assistant today 😛