Adding In Between Words
 

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.

Adding In Between Words
 

On Mon, 5 May 2008 06:41:00 -0700, Tool Outfitters
wrote:

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

Adding In Between Words
 

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

"Ron Rosenfeld" wrote:

On Mon, 5 May 2008 06:41:00 -0700, Tool Outfitters
wrote:

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

Adding In Between Words
 

On Mon, 5 May 2008 07:33:01 -0700, Tool Outfitters
wrote:

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

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