Excel Help.

Target · 03-20-2009, 07:16 AM

Can someone help me, got a problem with Excel, I’m sure it should be something simple but no idea what it is.
In cell E2 I have a list of codes shown as ‘9d, 11b, 10d, 7b, 10c, 7c, 13c, 2f’ but I need them all in separate cells hopefully N2 to U2. Is there a simple formula that can do that??
I don’t really want to have to type them all in as I’ve another 40 rows of them!
Cheers

Bungleau · 03-20-2009, 08:51 AM

Hmmm... tricky. Googling did turn this up:

Quote:

Split the contents of cells across multiple cells

You cannot split a cell or range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) of cells that was not previously merged. You can, however, divide the contents of unmerged cells and display them across other cells.

1. Select the cell, the range of cells, or the entire column that contains the text values that you want to divide across other cells. A range can be any number of rows tall, but no more than one column wide.

Important Unless there are one or more blank columns to the right of the selected column, the data to the right of the selected column will be overwritten.
2. On the Data menu, click Text to Columns.
3. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.

Note For help with completing all the steps of the wizard, click Help Button image in the Convert to Text Columns Wizard.

Give that a shot...

Target · 03-20-2009, 09:18 AM

Thanks very very much Bungleau!!

Bungleau · 03-20-2009, 09:30 AM

You're welcome

Learned something myself this morning...

Target · 03-20-2009, 11:03 AM

Well once you've learned something might as well go back home! Don't want to over do it on one day

Bungleau · 03-20-2009, 01:35 PM

I work at home, so mission 2 accomplished...

Target · 03-21-2009, 12:37 PM

Working from home, now that sounds like a good idea!
But thanks to moving house I am now only 2.5 miles from work! wooo

Bungleau · 03-21-2009, 03:06 PM

That's barely enough time to get the car warmed up in the winter...

03-20-2009, 07:16 AM	#1
Target Red Dragon Join Date: April 1, 2003 Location: The Midlands Posts: 1,571	Excel Help. Can someone help me, got a problem with Excel, I’m sure it should be something simple but no idea what it is. In cell E2 I have a list of codes shown as ‘9d, 11b, 10d, 7b, 10c, 7c, 13c, 2f’ but I need them all in separate cells hopefully N2 to U2. Is there a simple formula that can do that?? I don’t really want to have to type them all in as I’ve another 40 rows of them! Cheers __________________ Smoke me a kipper...I'll be back for breakfast!! If you can keep your head when all around are loosing theirs...you probably haven’t grasped the situation!!

03-20-2009, 09:18 AM	#3
Target Red Dragon Join Date: April 1, 2003 Location: The Midlands Posts: 1,571	Re: Excel Help. Thanks very very much Bungleau!! __________________ Smoke me a kipper...I'll be back for breakfast!! If you can keep your head when all around are loosing theirs...you probably haven’t grasped the situation!!

03-20-2009, 09:30 AM	#4
Bungleau 40th Level Warrior Join Date: October 29, 2001 Location: Western Wilds of Michigan Posts: 11,752	Re: Excel Help. You're welcome Learned something myself this morning... __________________ B Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last.

03-20-2009, 11:03 AM	#5
Target Red Dragon Join Date: April 1, 2003 Location: The Midlands Posts: 1,571	Re: Excel Help. Well once you've learned something might as well go back home! Don't want to over do it on one day __________________ Smoke me a kipper...I'll be back for breakfast!! If you can keep your head when all around are loosing theirs...you probably haven’t grasped the situation!!

03-20-2009, 01:35 PM	#6
Bungleau 40th Level Warrior Join Date: October 29, 2001 Location: Western Wilds of Michigan Posts: 11,752	Re: Excel Help. I work at home, so mission 2 accomplished... __________________ B Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last.

03-21-2009, 12:37 PM	#7
Target Red Dragon Join Date: April 1, 2003 Location: The Midlands Posts: 1,571	Re: Excel Help. Working from home, now that sounds like a good idea! But thanks to moving house I am now only 2.5 miles from work! wooo __________________ Smoke me a kipper...I'll be back for breakfast!! If you can keep your head when all around are loosing theirs...you probably haven’t grasped the situation!!

03-21-2009, 03:06 PM	#8
Bungleau 40th Level Warrior Join Date: October 29, 2001 Location: Western Wilds of Michigan Posts: 11,752	Re: Excel Help. That's barely enough time to get the car warmed up in the winter... __________________ B Save Early, Save Often Save Before, Save After Two-Star General, Spelling Soldiers -+-+-+ Give 'em a hug one more time. It might be the last.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Help please.	Target	General Discussion	2	09-22-2008 10:55 AM
Excel question	ZFR	General Discussion	2	03-28-2007 05:16 AM
Need help with Excel..	Kakero	General Discussion	3	11-15-2005 06:13 AM
VBA in Excel	Jorath Calar	General Conversation Archives (11/2000 - 01/2005)	5	02-10-2004 11:18 AM
Excel...Some Help Needed...	FelixJaeger	General Conversation Archives (11/2000 - 01/2005)	4	04-22-2003 08:58 AM