Remove spaces from a cell

Often when a list is imported from another application, you would find that there are unwanted spaces within cells. If there are spaces in a numeric cell, excel reads it as text field. This means no calculation can be carried out on them. For instance if a cell contains 1234 1 (space between 4 and [...]

Read Full Post »