Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Removing " from a cell

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Removing " from a cell

Resolved · Low Priority · Version Standard

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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 Edit> Replace

Excel articles

· Differences In Excel 2003, 2007 And 2010
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Microsoft Excel can ensure you keep on top of your finances
· Experience The Power Of PowerPivot
· What Are Sparklines In Excel 2010?

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips