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!
Deleting Part of a Cell
Cotta
Posts: 3,667 Forumite
in Techie Stuff
Hi All,
I want to delete the right hand section of a cell but leave what is on the right, I remember doing this once before with a scroll facility, however how do I get to that scroll option?
Thanks.
I want to delete the right hand section of a cell but leave what is on the right, I remember doing this once before with a scroll facility, however how do I get to that scroll option?
Thanks.
0
Comments
-
I'm guessing you mean in Excel...
There are a couple of ways:
#1 Manually double click on the cell and delete the bits you want (alternatively click on the bar just above the sheet, that has the data in it).
#2 Use a formula - assuming the text is in A1, and the result will be in B1
Click on the B1 cell and type:
=RIGHT(A1,4)
This will take the right-most 4 characters of the text in A1.
If you want to take all but the left-most 4 characters then
=RIGHT(A1,LEN(A1)-4)
Will work if the text is at least 4 characters long - if it may not be then:
=IF(LEN(A1)<4,"",RIGHT(A1,LEN(A1)-4))
The formula can be applied quickly to a large number of rows by using the "Edit -> Fill" menu option (assuming 2007 or prior versions of Excel - they moved everything around in 2010).
Mirno0
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.5K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards