Text to lines on iPad

PattyBB 0 Reputation points
2026-10-12T01:06:44.18+00:00

When I try to copy/paste data from an email into an excel spreadsheet I can normally choose the format. I don’t have the same choice on an iPad. I need the data to split into lines rather than columns.

Microsoft 365 and Office | Excel | For home | iOS
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EmilyS726 272.9K Reputation points Independent Advisor
    2026-10-12T02:04:54.2166667+00:00

    Hello,

    Excel on iPad has fewer paste options than the desktop version.

    If your data is pasted across columns, you can use the TRANSPOSE function to turn it into rows.

    Paste your data into Excel.

    Select an empty cell.

    Enter =TRANSPOSE(A1:C1) and press Enter.

    Replace A1 with the range containing your data.

    However, if everything is pasted into one cell, the solution is different.

    Can you clarify whether your data appears in one cell or spreads across multiple columns when you paste it?

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.