Skip to main content

Post content has been hidden

To unblock this content, please click here

Any excel wizzes about?

giddy, 5 April, 2011 at 13:36 Posted on Off Topic Posts 0 2

Saved

Reply

Report
Hide content

I've just been upgraded from a very old (2003) version of excel. In there I could use "Text to columns" to divide a comma seperated line of text into columns. Office 2010 doesn't seem to have this option. Is there a new way to do this?

Fingers crossed for someone who knows what I'm wittering about!

Report
Hide content

2 replies

Latest activity by giddy, 5 April, 2011 at 14:45

Beginner August 2009
FIONATS73 · 5 April, 2011 at 13:39
Report

Hide content
I have just got this last week myself so can not help you as yet sorry have you googled it in microsoft?
- Reply
Beginner July 2012
*JLS* · 5 April, 2011 at 13:42
Report

Hide content
Hello, if you click on the data tab at the top (home, insert, page layout, formulas then data) then there is an option for Text to Columns icon in the data tools section.
- Reply

giddy · 5 April, 2011 at 14:45
Report

Hide content
THANK YOU!

I knew it would be there somewhere.
- Reply

Win £3,000 for your wedding

Join Hitched Rewards, where you can win £3,000 simply by planning your wedding with us. Start collecting entries, it's easy and free!