📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel Help please - Any experts out there?

Options
Hi all,

Please could someone help me with the following: If you have a long row of phrases

e.g.
dog
happy dog
brown dog
brown happy dog
happy brown dogs
happiest brown dog
brown dog that is happy

etc etc

Is there a quick way to split each word into it's own column? If you could help me I'd be so happy as it will save me lots (and lots) of time.

Comments

  • espresso
    espresso Posts: 16,448 Forumite
    Part of the Furniture 10,000 Posts Combo Breaker
    tincat wrote: »
    Hi all,

    Please could someone help me with the following: If you have a long row of phrases

    e.g.
    dog
    happy dog
    brown dog
    brown happy dog
    happy brown dogs
    happiest brown dog
    brown dog that is happy

    etc etc

    Is there a quick way to split each word into it's own column? If you could help me I'd be so happy as it will save me lots (and lots) of time.

    Copy & paste the phrases into excel.
    Select the first column.
    Data, Text to columns.
    Job done.
    :doh: Blue text on this forum usually signifies hyperlinks, so click on them!..:wall:
  • tincat
    tincat Posts: 935 Forumite
    Fantastic and so quick

    Thanks
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 351.2K Banking & Borrowing
  • 253.2K Reduce Debt & Boost Income
  • 453.7K Spending & Discounts
  • 244.2K Work, Benefits & Business
  • 599.2K Mortgages, Homes & Bills
  • 177K Life & Family
  • 257.6K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.