removal of delimiter

[raja]

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

 

[galimi]

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)

 

[George Nicholson]

Copy column E to F. Highlight F
Data>Text-To-Columns
-"Delimited">Next
- Check both "Space" and "Other". In the box by "Other" enter "-" (with
no quotes)
- Finish

HTH,

 

[raja]

can u give me the VBA macros script
thank u

Copy column E to F. Highlight F
Data>Text-To-Columns
-"Delimited">Next
- Check both "Space" and "Other". In the box by "Other" enter "-" (with
no quotes)
- Finish

HTH,

 

[Dave Peterson]

If you record a macro when you do it manually, you'll have the code that you
need.