Ironworks Gaming Forum - View Single Post

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

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!!