Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 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?
tincat
Posts: 935 Forumite
in Techie Stuff
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.
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.
0
Comments
-
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:0 -
Fantastic and so quick
Thanks0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179.1K Life & Family
- 263.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards