What is the easiest way to remove errant spaces/letters etc from cells in numeric spreadsheets you have had to import from a different format? From the beginning and from the end of cells. Thanks.

Hi Matt

Thank you for your question

For Spaces I suggest using the Trim funtion

In Excel this simply takes the data in a specified field and removes any blankspaces except thse between words

As to errant letters, if the same letter appears regularly, select the range of cells and click on Edit-Replace.

In the resulting dialog, type the value to be replaced in the replace combo and leave the with box blank. Click OK and it will remove all instances of the errant letter.

Hope this helps

Regards

Stephen