Matt has attended:
Access Introduction course
Access Intermediate course
Access VBA course
Access Advanced course
Access/Excel
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.
RE: Access/Excel
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
