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):
If you want a fixed result rather than a calculated one, you could then copy the result and use 'paste as values'. 

