| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for deleting a particular string and inserting commas in it
Hi,
I need a MACRO FOR THIS URGENTLY I have a long string namely: Yes TAX Invoicing No multi purpose Yes summer time No tuna tub The yes and No option varies from a row to row i Want a Particular Output deleting ALL the NO's and the particular string after no and all yes should appear in the row with proper commas Desired OUTPUT: TAX Invoicing, Summer time -- Purple |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting commas | Excel Discussion (Misc queries) | |||
| String separated with commas | Excel Programming | |||
| Inserting and deleting spaces with a macro | Excel Programming | |||
| removing commas from a string | Excel Programming | |||
| Excel – Macro Problem – Inserting, Appending Data, Deleting | Excel Programming | |||
Threaded Mode
