Share via

Copy a numbered list into one cell in excel

Anonymous
2018-09-20T17:15:46+00:00

I'm trying to copy a numbered list into one cell in an excel spreadsheet.  It's text only and when I paste into excel, the list is split into multiple cells which throws off the entire spreadsheet.  I already have wrap text enabled on the cells.  What else do I need to do to make this work?  Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

DaveM121 884.5K Reputation points Independent Advisor
2018-09-20T17:21:15+00:00

Hi ProfK1997

Instead of clicking that cell, double click the cell, so you get a flashing cursor, then paste that list into the cell

That's It

Was this answer helpful?

6 people found this answer helpful.
0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2018-09-20T18:28:16+00:00

    Another option is to after selecting the cell, paste into Formula Bar.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. DaveM121 884.5K Reputation points Independent Advisor
    2018-09-20T17:28:38+00:00

    Hi ProfK1997, Glad to Help!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-09-20T17:27:31+00:00

    Thank you!  It worked.

    Was this answer helpful?

    0 comments