text columns

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 » Text to Columns

Text to Columns

resolvedResolved · Low Priority · Version 2003

Gemma has attended:
PowerPoint Introduction course
Excel Advanced course

Text to Columns

Hi,

Can you tell me if you can do text to columns when you have pressed alt return to go down a line in the cell.

Edited on Fri 9 May 2008, 16:13

RE: Text to Columns

Hi Gemma, Thank you for your post, in answer to your question; well you can but you will lose the second and any subsequent lines, its a bit like merging the cells, you will lose the second line;
For those who are wondering what is going on I will put in a little explanation here: (Even if you don't have an immediate use for this one, it's one of those handy little pieces of information that may just get you out of a jam one day. :-)

For example your Excel file has both first and last names in the same cell?
Now how are you supposed to sort that list alphabetically by last name when first name is listed first?
The answer is that you can't


 

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


Server loaded in 0.09 secs.