Deleting Part of a Cell

Cotta

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.

Mirno

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).

Mirno