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..

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..

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..

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..

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