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 » Removing " from a cell
Removing " from a cell
Resolved · Low Priority · Version Standard
Fri 15 Feb 2008, 10:16Delegate Sally said...
Sally has attended:
Excel Intermediate course
Removing " from a cell
Hi,
i know there is a quick and easy way of doing this without going into each one adn deleting it, i was just wondering if you could help me.
I have exported some data into excel and now in each cell the data is seperated buy "" i.e. "sally" how do i remove that quickly?
thanks
Fri 15 Feb 2008, 12:12Trainer Rajeev said...
RE: Removing " from a cell
Dear Sally
Thank you for attending Excel Intermediate Course. I hope you enjoyed the training.
This is a common error that appears when you try import data from other source.
The solution is quiet Straight forward.
Step 1: Click anywhere inside the data
Step 2: Choose [b]Edit> Replace
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:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
