| Home |
| Search |
| Today's Posts |
|
#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.. |
| 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) | |||
![galimi[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
