| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and remove a string of a cell value with comma as delimiter
can anyone help me on this?
i have columns of data which has the format of (something1,something2, something3, others) the string "somthing1", "somthing2", "somthing3" are consistent, and not all may appear at the same time, while the part "others" may vary. I want to extract the "others" part, if the cell has how can i do this in a macro? i donot want to modify the original cell, but will store the "others" in another sheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
| Excel - Find & Replace text in a string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
