Harshad;233734 Wrote:
I have many mail ids in excell sheet in column A. I want to separate
the
username and domain name in Column B and Column C respectively. e.g.
Column
A: , Column B: abcde and Column C: gmail.com


thanks in advance

Harshad

Try Data-Text to columns - Check " delimited" enter @ as delimiter - OK


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65249