Easy quesiton: Text sorting.

  • Thread starter Thread starter david987
  • Start date Start date
D

david987

I'm just wondering how can I make text to be sorted from the right to
left...
Instead of having:

Hello
Example
One

Have:

olleH
elpmaxE
enO


The reason I want to do this is because I have a huge email like ( ~
3000 ) and I want to sort by provider, i'd have to delete the .com's
and .net's but then i could sort by "aol's" or "hotmail's".
If what I'm asking seems impossible, what can I do to sort the emails
by providers?
Any code that when @aol.com matches, it goes to a second column ?

I'm new at this, thank you for your time !
 
My suggestion:

Copy the column containing the e-mail addresses.
Paste it in an empty column
Select the entire column and choose Data -> Text to Columns
Choose the @ symbol as the delimiter

This will give you two columns one will have the pre @
ie david.u6iom and the second will have the post @
ie excelforum-nospam.com

Select all of your data and choose Data -> Sort
Sort by the column of providers

Dan E
 
Hi,



Make a new column with this equation in the cells, then sort on this column.



=MID(A1,FIND("@",A1)+1,LEN(A1))



This will extract all after the @.
 
Try highlighting all the addresses and selecting Data >
Text To Columns and specifying a delimiter of "@".
If an e-mail address was (e-mail address removed) it would
separate it into two columns "mark" in the first
and "hotmail.com" in the second.
 
<Data> <Sort> <Options> button,
Click "Sort Left To Right" then <OK>
Then click "Descending" in the appropriate row.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Ok so I've done what Dan E suggested, and I've got it working, I now
have several listing for each ISP.
But the problem is that the domains are separate from the
usernames...How can I merge the two collumns with the @ in between them
?

Thanks !
 
I guess there's something to be said about reading the entire question
before one posts a suggestion.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

RagDyer said:
<Data> <Sort> <Options> button,
Click "Sort Left To Right" then <OK>
Then click "Descending" in the appropriate row.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Click to expand...
 
When you did text to columns, there's an option where to put the data. You
could have put it different columns and left the orginal alone.

But if you didn't, you can combine the data with a formula like:

=a1&"@"&b1
 
You're absolutely correct ... but as I later commented ... it will perform
exactly as your *first sentance* requested.
Are you implying that the entire question should be read and answered ? <bg>


Regards,

RD
 
Back
Top