Get rid of those leading spaces and apostrophes
Have you ever imported data into Excel and discovered lots of leading spaces? Or leading Apostrophes? I know I have. This is not very useful as a leading spaces do not allow for effective sorting.
Here is how the Trim function can help to remove them.
Click on the cell with the text that you wish to trim ( in my example the first few cells have a leading space and the last few have an apostrophe (which does not show)
Press Enter – the leading space or apostrophe is now gone
So you can see that the result shows in the cell (1) however in the background is still a formula (2)
Change the formula to show values
Having copied the formula to all the cells in the column, I now want to change the formula to values so that I can use the names in other ways.
Select the cells with the formula and copy them
Use Paste Special
Put your cursor where you want the new values to be (1)
Click on the drop down arrow under the paste icon (2)
Select Paste Values (3)
How is this tip going to save you time? Let me know how you will use it.