excel vba courses - excel formating

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel vba courses - Excel 2003. Formating Columns

excel vba courses - Excel 2003. Formating Columns

resolvedResolved · Low Priority · Version Standard

Maria has attended:
Excel Intermediate course

Excel 2003. Formating Columns

I had a problem transferring data from another source, excel wasn't recognising that some numbers were numbers and therefore it didn't sort them in numerical order.

Help please!

RE: Excel 2003. Formating Columns

Dear Maria

Thank you for attending Excel Intermediate Course.

Following function should be able to resolve the problem.

Normally when you copy and paste "numbers from the internet they are copied with extra spaces or non-breaking spaces [Char(160)] attached.

Following should help to resolve the problem:

Please insert a blank new column to the right hand side of the column you want to convert and type the following function to one cell.

=SUM(TRIM(SUBSTITUTE(cell,CHAR(160),"")))

Please note that cell in the above formula should be replaced with the appropriate cell that contains the number you want to convert.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn


 

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips


Server loaded in 0.09 secs.