+ Reply to Thread
Results 1 to 5 of 5

How to split words from one cell into other cells

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    How to split words from one cell into other cells

    Hi guys

    I don't think I can use text to columns here...

    I have cell A1 populated with words including single words, up until 2-3 words

    I.e

    Cell A1:
    Cancelled
    Still waiting
    never received it
    Bad
    Service

    How can I split all the content from A1 into A1, A2, A3 and so on?

    Text to columns is not helpful for me - unless i`m selecting something wrong.

    Pls advise. thank you!

    Update I have the option to add commas to my data too but this is still going into ONE CELL and I want to split these across cells... all in column A
    Last edited by rayted; 06-18-2020 at 08:58 AM.
    Thanks,

    R.



  2. #2
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    Germany
    MS-Off Ver
    365
    Posts
    490

    Re: How to split words from one cell into other cells

    Text to columns should work, check Delimited and then check the boxes Space and Other and in the other field press Ctrl+j (IBM legacy for line break), then finish.
    This should work.

    Regards

  3. #3
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    897

    Re: How to split words from one cell into other cells

    Hi rayted,
    Do you mean all the words listed in the 5 rows (from 'Cancelled' to 'Service') are in cell A1 and you want the words in each row in a separate cell?
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

  4. #4
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: How to split words from one cell into other cells

    amazing thank you RaulSerg!

  5. #5
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    Germany
    MS-Off Ver
    365
    Posts
    490

    Re: How to split words from one cell into other cells

    You're welcome, thanks for the feedback.

+ 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. [SOLVED] Need to split one column into two columns based on the number of words per cells
    By terryhenderson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2018, 03:42 AM
  2. [SOLVED] Split words in a cell
    By thalian in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-14-2017, 05:56 AM
  3. split words in a range of cells
    By ourgarden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2013, 07:01 PM
  4. Split Text into 2 Cells Keeping Whole Words
    By keithm_007 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2012, 06:12 AM
  5. Replies: 2
    Last Post: 05-06-2011, 09:14 AM
  6. Split words with number under one cell
    By Kenji in forum Excel General
    Replies: 5
    Last Post: 04-20-2010, 06:56 AM
  7. How do I split a cell of 2 words into two cells
    By Steven S in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2005, 11:05 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