Forum Discussion

johnsboxftm's avatar
johnsboxftm
Brass Contributor
Feb 03, 2023

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...
  • OliverScheurich's avatar
    OliverScheurich
    Feb 03, 2023

    johnsboxftm 

    =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.

     

Resources