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