I am trying to run a Trim and Clean formula on a file, but using the "fill" feature only grabs the value from the first column. The same happens when I try to do a vlookup. I tried copying and pasting the data into a new workbook, but that did not help. Filters are not on. I was able to add consecutive numbers to the file using the fill feature (ex: 1, 2, 3) and had no issues.
I have attached the sample workbook with two sheets added: Forum BEFORE and Forum AFTER. In the BEFORE sheet, you'll see that my trim and clean formulas are only copying down the results from the first cell.
Bookmarks