Is there a way in microsoft excel or open office calc to remove the last n chars from a field.
Lets say all fields in one column are 31 chars long and I want to remove the last 6 chars.
Is there an easy way with excel or calc to do this?
Is there a way in microsoft excel or open office calc to remove the last n chars from a field.
Lets say all fields in one column are 31 chars long and I want to remove the last 6 chars.
Is there an easy way with excel or calc to do this?
If your data is in A1, you could put the following formula in B1 (or elsewhere):
=LEFT(A1,LEN(A1)-6)
If you want a fixed result rather than a calculated one, you could then copy the result and use 'paste as values'.
Ctrl
+Down arrow
. You should be at the bottom of your data. Select the bottom cell in the column you want to fill with the formula, press Shift
+Ctrl
+Up arrow
, then press Ctrl
+D
.
– Martha
Nov 5 '10 at 18:51