let us say there is an excel workbook having a few columns. one column has values text but they have to be trimmed i.e. all rows under that column has to be trimmed even when we put values in there which may spaces in them.
how to apply a function for a column? i know how to apply for a cell but i could not find the way for the entire column.
any help is appreciated.
applying trim on a column in excel
Moderator: General Moderators
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
Circular reference??
I understand your question as follows, You have A2-AN which needs to be applied trim function.Then
and press enter.
Hold the mouse over the cell and drag and drop till 'AN', this should apply the formula for the entire column.
I hope Im right in my understanding.
I understand your question as follows, You have A2-AN which needs to be applied trim function.Then
Code: Select all
=trim(A2);Hold the mouse over the cell and drag and drop till 'AN', this should apply the formula for the entire column.
I hope Im right in my understanding.
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
you have understood things correctly but the solution does not work. have you tried it in an excel sheet?dude81 wrote:Circular reference??
I understand your question as follows, You have A2-AN which needs to be applied trim function.Thenand press enter.Code: Select all
=trim(A2);
Hold the mouse over the cell and drag and drop till 'AN', this should apply the formula for the entire column.
I hope Im right in my understanding.
it says 'the formula you typed contains an error' when i put for the cell a2 the formula =trim(a2). thanks.
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
alright, looks like this problem cannot be solved other than the solution you have said now.dude81 wrote:Yes, I understood your problem, Put the formula in some new column and copy and paste the result back over the original coloumn.
it is bad to know that there is no way to enforce a trim on a column.