| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removal of delimiter
i have contents in column E like
E Arun - Ram Philips - rook guru - kar i want to remove - and store it in the following fashion F G Arun Ram Philips rook guru kar how can i do this in macros kindly help me.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removal of delimiter
Place the following formula in column f
=LEFT(E1,FIND(" ",E1)) and the following formula in column g =RIGHT(E1,LEN(E1)-FIND("-",E1)-1) -- http://HelpExcel.com 1-888-INGENIO 1-888-464-3646 x0197758 "raja" wrote: i have contents in column E like E Arun - Ram Philips - rook guru - kar i want to remove - and store it in the following fashion F G Arun Ram Philips rook guru kar how can i do this in macros kindly help me.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removal of delimiter
Copy column E to F. Highlight F
DataText-To-Columns -"Delimited"Next - Check both "Space" and "Other". In the box by "Other" enter "-" (with no quotes) - Finish HTH, -- George Nicholson Remove 'Junk' from return address. "raja" wrote in message ... i have contents in column E like E Arun - Ram Philips - rook guru - kar i want to remove - and store it in the following fashion F G Arun Ram Philips rook guru kar how can i do this in macros kindly help me.. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removal of delimiter
can u give me the VBA macros script
thank u "George Nicholson" wrote: Copy column E to F. Highlight F DataText-To-Columns -"Delimited"Next - Check both "Space" and "Other". In the box by "Other" enter "-" (with no quotes) - Finish HTH, -- George Nicholson Remove 'Junk' from return address. "raja" wrote in message ... i have contents in column E like E Arun - Ram Philips - rook guru - kar i want to remove - and store it in the following fashion F G Arun Ram Philips rook guru kar how can i do this in macros kindly help me.. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
removal of delimiter
If you record a macro when you do it manually, you'll have the code that you
need. raja wrote: can u give me the VBA macros script thank u "George Nicholson" wrote: Copy column E to F. Highlight F DataText-To-Columns -"Delimited"Next - Check both "Space" and "Other". In the box by "Other" enter "-" (with no quotes) - Finish HTH, -- George Nicholson Remove 'Junk' from return address. "raja" wrote in message ... i have contents in column E like E Arun - Ram Philips - rook guru - kar i want to remove - and store it in the following fashion F G Arun Ram Philips rook guru kar how can i do this in macros kindly help me.. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TTC delimiter restriction | Excel Discussion (Misc queries) | |||
| CSV - no delimiter at end of line | Excel Discussion (Misc queries) | |||
| point as delimiter | Excel Discussion (Misc queries) | |||
| Comma delimiter | Excel Worksheet Functions | |||
| Tab Delimiter File | Excel Discussion (Misc queries) | |||
Hybrid Mode
