Assuming the data you want to split is in cell A!, you can insert a new row 2
and put your data into cels A1 and A2, then merge cels B1& B2, C1& C2, D1& D2
etc. It's more work, but you'll have the results you wanted.

"blondie" wrote:

i need to put two split rows inside of one cell