+ Reply to Thread
Results 1 to 2 of 2

Copying multiple words in one go, but pasting each word in its own cell

  1. #1
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    214

    Copying multiple words in one go, but pasting each word in its own cell

    I have a list of many words with a space between each word from a text file, so there is no formatting, well other than the spacing.
    If I copy this list of words, how can I tell Excel to detect the spaces and put each sequential word in its own cell?

    I noticed there is a Text to Columns option, but where is the Text to Row option, as that is what I need?

    Actually, Text to Columns is exactly what I needed! My mistake, how can I delete this post?
    Last edited by Modify_inc; 11-20-2021 at 02:42 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Copying multiple words in one go, but pasting each word in its own cell

    There is no need to delete it. You marked it SOLVED and that is good enough.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup a specific word within a cell containing multiple words?
    By Sundaysurfing in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-22-2021, 05:17 AM
  2. Color each word in the cell with inputbox and multiple words in it at once
    By 7absinth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2016, 09:39 AM
  3. Replies: 1
    Last Post: 06-04-2014, 07:15 AM
  4. Formula to recognise one word from multiple words in the same cell
    By JLucy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-27-2013, 11:48 AM
  5. Copying and Pasting Long Formula from Word into Excel Cell
    By whitedonkey11 in forum Excel General
    Replies: 1
    Last Post: 05-26-2010, 05:38 PM
  6. Copying and pasting between words
    By sentinela in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2009, 07:17 PM
  7. Copying Cell data and pasting into word document?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-07-2006, 05:41 AM

Tags for this Thread

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