CDROM-Guide forums
{google728}

Go Back   CDROM-Guide forums > Main Forums > Open to All Computer Related Topics
FAQ Calendar Mark Forums Read
Open   CSec   Data   DevDrv   CoOp   Audio   CDRW   CDG   VCD   DVD   HD DVD   Mac   VGB   PS2   DC   Xbox  

{google160_081509}
Reply
 
Thread Tools Display Modes
  #1  
Old Jan 14, 2004, 02:11 PM
shicks1014 shicks1014 is offline
Junior Member
 
Join Date: Apr 2003
Posts: 36
Question split cells in Excel

sponsored links
{postbit1_5-Ad}
 
Can someone tell me how I can take a text cell in Excel and create two seperate cells? For example:
ABC12345 as one cell needs to be ABC and then 12345 as two cells. I have an entire column of cells that need to be split and hopefully I won't need to do this completely manually. Any help would be great! Thank you.
Reply With Quote
  #2  
Old Jan 14, 2004, 05:25 PM
orcus orcus is offline
Member
 
Join Date: Apr 2003
Location: Scotland
Posts: 180
Default

look up LEFT and RIGHT worksheet functions. The text you are dealing with would have to be a fixed width but once you've done it once you can paste the formula all the way down a column and viola
Reply With Quote
  #3  
Old Jan 15, 2004, 04:02 AM
Kalimero Kalimero is offline
Member
 
Join Date: Jul 2001
Posts: 100
Default

ABC 12345

if your text had a blank space between ABC and 12345 you can, and this is the formula to extract ABC =LEFT(C14,FIND(" ",C14,1))

=RIGHT(C22,LEN(C14)-FIND(" ",C14)) to extract 12345

hth..
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange thing happens when I open excel documents!!! hssc11045 Open to All Computer Related Topics 2 Sep 18, 2003 10:47 AM
How not to print errors in excel? king nero Open to All Computer Related Topics 1 Aug 11, 2003 05:58 PM
moving between cells in excel?? chimpuk Open to All Computer Related Topics 2 May 29, 2003 06:17 AM
Excel Help Please? psx4u Open to All Computer Related Topics 2 Oct 11, 2002 11:15 AM
Excel problem/virus ?? Goplanit Open to All Computer Related Topics 1 Aug 10, 2002 11:39 AM


All times are GMT -5. The time now is 01:41 PM.

{google300_081509}


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright © 1996-2009 CDROM-Guide.com. All rights reserved
{intellitxt1264_061606}
{intellitxt1264_061606}