I have a worksheet which has 5 lacks of rows and which contains a column name :- VENDOR NUMBER
Now i want to create a macro which calculate the new column called :-Supplier number 2

Formula is :- Supplier Number 2: trim(VENDOR NUMBER)
Supplier Number 2 column must be the last column

how can i write a macro for this


Thanks in advance