I wrapped a two line cell. I sorted but the wrapped cell didn't g.

[Mike's cells]

I am putting a list of names on excell. Some have to go on two lines in one
cell. I wrapped that cell. But when I sort data from ascending to
descending the wrapped cell does not go with that info. Any suggestions

 

[Debra Dalgleish]

When I format a cell with Wrap Text, and sort the list, the formatting
stays with the cell. Are the values typed in your list, or are they
links to other cells?

 

[Jon Peltier]

Mike -

Did you include the column with wrapped cells in the selection to be sorted?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______