98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access/Excel
Access/Excel
Resolved · Low Priority · Version Standard
Thu 7 Feb 2008, 17:22Delegate Matt said...
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.
Sun 10 Feb 2008, 13:19Trainer Stephen said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
