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

	98.1 % recommend us
	More live stats...

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

Training information:

Text to columns

Resolved · Low Priority · Version 2010

Reply Thu 12 Jan 2012, 16:35Delegate Joanna said...

Joanna has attended:
Excel Advanced course
Project Management course

Text to columns

Can you save a preset spacing for data, or do you have to do it via macro's

For upcoming training course dates see: Pricing & availability

Reply Fri 13 Jan 2012, 11:54Trainer Rodney said...

RE: Text to columns

Hello Joanna,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding text to columns spacing.

I'm not sure what you are looking for here so please give more details and I'll see if I can help with this one.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Excel articles

· Update Your VAT Rates In Excel
· So what's new in Excel 2007?
· Adding Effects To Drawing Objects In Excel
· Microsoft Excel Training Course
· Formulas In Excel: The Very Basics

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

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips