LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kelly Edwards
 
Posts: n/a
Default splitting a cell in Excel

That doesn't do what I want. That moves the data into adjoining columns. I
want there to be two cells under the same column. For example, say I want to
split cell B11 into two cells...I want there to be like a B11a and a B11b
rather than sending part of the data over to C11 because I already have data
there that I can't move. Does that make sense? Is that even a possibility?

"dkuz" wrote:


Click on the cell that you want to split
Click on Data...text to columns
Click on the "fixed width" radial
Click next
Click next again
Click Finish


--
dkuz
------------------------------------------------------------------------
dkuz's Profile: http://www.excelforum.com/member.php...o&userid=31536
View this thread: http://www.excelforum.com/showthread...hreadid=512246




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Word Wrap Problem within cell Dan S. Excel Discussion (Misc queries) 1 October 17th 05 03:54 PM
How can I populate an Excel cell based on the data in another cell JerseyBoy Excel Worksheet Functions 3 September 30th 05 03:53 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"