You can specify the width of the column, set it to wordwrap then use autofit
and it will put the correct number of rows.

"George Lee" wrote:

I have lengthy string that I want to display in entirety. I would like to
pick how many cells wide to merge and based on that, have Excel calculate for
me how many rows I need. How is this done?