Forum Discussion
Solved
Using VLOOKUP and TRIM
Someone helped me yesterday with VLOOKUP. I am not doing it right (of course). This is what I am trying to do: I want to type in on sheet "January 2023" cell B3 a specific city name and have ce...
=TRIM(A1)You can apply this formula in cell C1 and copy it down. Then you can copy the entire range e.g. C1:C1147 and paste only values. In the example i've pasted only values in column D but you can paste only values in column A as well. Then you can delete all the TRIM formulas from column C.
I will give it a try. As for the TRIM function ... I want to remove the extra spaces. Do I have to do that for each individual line or can I do the entire column?
=TRIM(A1)You can apply this formula in cell C1 and copy it down. Then you can copy the entire range e.g. C1:C1147 and paste only values. In the example i've pasted only values in column D but you can paste only values in column A as well. Then you can delete all the TRIM formulas from column C.