Adding In Between Words

[Tool Outfitters]

I am trying to figure out how to mass edit a column that contains keywords
within each cell. For example:

fuel cap pressure tester

I would like to add commas in between the words...

fuel, cap, pressure, tester

Any help would be greatly appreciated.

 

[Ron Rosenfeld]

I am trying to figure out how to mass edit a column that contains keywords
within each cell. For example:

fuel cap pressure tester

I would like to add commas in between the words...

fuel, cap, pressure, tester

Any help would be greatly appreciated.

With your original in A1:

=SUBSTITUTE(TRIM(A1)," ",", ")

--ron

 

[Tool Outfitters]

Thank you for the quick reply Ron. This is definately what I was looking for.

 

[Ron Rosenfeld]

Thank you for the quick reply Ron. This is definately what I was looking for.

Glad to help; thanks for the feedback.
--ron