Excel 2007, how do you write the clean or trim command into a spreadsheet? I am trying to remove the leading space in a column and excel help menu is no help.
Where do i type =trim or =clean in the cell above the data or in the cell with the data?
Header: col A Row 1= Supervisor
Data: Col A Row 2-2,000 = Supervisor's name list (with a leading space)
Where do i type =trim or =clean in the cell above the data or in the cell with the data?
Header: col A Row 1= Supervisor
Data: Col A Row 2-2,000 = Supervisor's name list (with a leading space)