Hi Eric,

On your last question:

Use DataText to Columns, wit a space as separator. Then sort the columns (Options, Left to right)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"EC" wrote in message ...
| ok, I'll give it a shot. Ome other questions, on a different note. Lets say
| I have a cell that has a whole bunhc of differents words in this 1 cell. Is
| there a way I can list these words in alphabetical order?
|
| Eric
|
| "EC" wrote:
|
| All,
|
| I have a worksheet full of data that is sorted by account number. I wasnt
| to write a lookup up formula that will look at the 'data tab' and if the
| account num,ber matches a certain account, then it will pull all of the
| information for that account number. For example, in colunm A there are a
| list of account numbers and from columns b thru z there is info. I want to
| write a formula that will lookup up the account number I want from column A
| and if it matches, give me all of the other info.
|
| Any and all help is greatly appreciated.
|
| Eric