| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING WORDS TO THE LEFT SIDE OF AN EXCEL SHEET | Excel Discussion (Misc queries) | |||
| adding words | Excel Discussion (Misc queries) | |||
| Word Formating & Words Adding | Excel Discussion (Misc queries) | |||
| Adding words up in a range | Excel Discussion (Misc queries) | |||
Linear Mode
