+ Reply to Thread
Results 1 to 7 of 7

How do I keep all text in the same cell?

  1. #1
    Registered User
    Join Date
    07-10-2007
    Posts
    11

    How do I keep all text in the same cell?

    I am trying to paste a large amount of text (HTML) into a single cell
    but when I do this a lot of it goes into the cells below. In other
    words, it breaks it up and puts different parts of the text into
    different cells.

    How can I get all of it to stay in the same cell?

    Thanks!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Paste it in the formula bar after you click the cell you want to put it in.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    07-10-2007
    Posts
    11
    That worked. Thanks, NBVC!

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    You're welcome.

  5. #5
    Registered User
    Join Date
    07-10-2007
    Posts
    11
    Now I want to copy this same cell of text and paste it into about 3000 cells in the same column. What is a fast way of doing this?

    Thanks!

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    did you try copying that cell, selecting all of the 3000 cells and pasting.

  7. #7
    Registered User
    Join Date
    07-10-2007
    Posts
    11
    Thought I had tried that but I guess not because that worked.

    Thanks again, NBVC, you have made this a productive day for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1