I have the following in column A: Abraham, Mike [email protected]
I need to have Abraham, Mike in column A
and
[email protected] in column B.
Can someone help me with this problem?
Thanks,
Sal
I have the following in column A: Abraham, Mike [email protected]
I need to have Abraham, Mike in column A
and
[email protected] in column B.
Can someone help me with this problem?
Thanks,
Sal
Assuming that your data is in Cell A1, try these (untested) formulas ...Originally Posted by Sal Iaccarino
To get the person's name: =left(A1,len(A1)-find(" ",A1))
To get the email address : =right(A1,len(A1)-search(" ",A1,search(" ",A1)+1))
Hope this helps.
Last edited by BenjieLop; 02-08-2005 at 01:00 AM.
BenjieLop
Houston, TX
Hi Sal,
Highlight the cell then choose Data, text to columns, and accept fixed
width. Click on finish and bingo!
--
Ken Russell
[email protected]
Remove yourhat to reply by e-mail
..
"Sal Iaccarino" <[email protected]> wrote in message
news:[email protected]...
>I have the following in column A: Abraham, Mike [email protected]
>
> I need to have Abraham, Mike in column A
> and
> [email protected] in column B.
>
> Can someone help me with this problem?
>
> Thanks,
>
> Sal
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks