Adding In Between Words

  • Thread starter Tool Outfitters
  • Start date
T

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.
 
R

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.
Click to expand...

With your original in A1:

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

--ron
 
T

Tool Outfitters

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