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 Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2007
Tue 19 Feb 2013, 14:23Delegate Faye said...
Faye has attended:
Excel Pivot Tables course
Excel
I often copy data into spreadsheet and sometimes i find there is a space before the word in the cell?
How can i get rid of this in mass?
Tue 19 Feb 2013, 14:35Trainer Gary said...
RE: Excel
Hi Faye
Thanks for getting in touch. This is a common problem. To fix this you will need a spare column where you can enter a new formula to remove the excess spaces.
In the spare column, use the TRIM function to clean up the cell. Assuming your piece of data is in cell A1, it will look like this:
=TRIM(A1)
The cleaned-up result will be left in the cell. Now of course you can fill the formula down the rest of your data.
To tidy it up you will probably want to Copy and Paste Special > Values to be left with the result rather than the formula.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
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. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |
