Forum home » Delegate support and help forum » Microsoft Access Training and help » Access/Excel
|
|
|
The UK's most regular 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/Excel
Resolved · Low Priority · Version Standard
Reply 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.
For upcoming training course dates see: Pricing & availability
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
|