Hi,

I am trying to trim a column using a formula but the problem is that the column reference wont always be the same, It could be column B or column C etc. What I cant do is hard code the column references as can change, so what I specifically need to do is:

1. Find 'AS_DESCRIPTION' which will be the column used.
2. Go to the right of the data set to find the first empty cell to type the formula in and drag formula down to the bottom.
3. Then copy the trimmed formula and paste over the original data.
4. Delete formula used column
5. Repeat the same for a column named 'AS_DESCRIPTION_LD'

Any help is appreciated
V