| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy text with comma eliminated
Dear all,
I have a series of text seperate by comma in Column A A shop, table, toy, car mon, light, book radio, phone now I want to copy them one by one to Column B, with the comma eliminated B shop table toy car mon light book radio phone How to do it by formula? thanks Kent |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula do I use to copy only text on left side of a comma? | Excel Worksheet Functions | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Eliminated compatibility between Microsoft products (Excel to FoxP | Excel Discussion (Misc queries) | |||
| How do I open a csv file and not have leading zeros eliminated | Excel Discussion (Misc queries) | |||
| Lotus 1-2-3 help has been eliminated from the transition menu. D. | Excel Discussion (Misc queries) | |||
Hybrid Mode
