I have a column with cells that have data on 2 lines. On line is the product
name, line 2 is the product manager. To get them to appear in 1 cell but on
2 lines, I do an ALT-Enter [Actually, I take 2 other cells and do a
=concatenate(a1,char(10),b1)] at the end of the first line. Looks great but
doesn't sort correctly. If the values of 2 cells were

501
John Doe

and

10029
Jane Doe

it would sort those 2 rows with 10029 appearing first. What's a good way to
resolve this problem that doesn't require any knowledge of macros?
Thanks