Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DC DC is offline
external usenet poster
 
Posts: 42
Default I need to split a cell into 4 cells and keep in the same column


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,393
Default I need to split a cell into 4 cells and keep in the same column

Data | Text to Column ?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dc" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default I need to split a cell into 4 cells and keep in the same column

With the amount of detail provided...............

How about a guess?

You have 4 words in A1 and want them placed in A:A4

Select A1:A4 and EditFillJustify


Gord Dibben MS Excel MVP

On Tue, 19 Sep 2006 13:02:02 -0700, dc wrote:


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,090
Default I need to split a cell into 4 cells and keep in the same column

Not much to go on. You say "split" so I presume that you want only a
portion of the contents of the cell put into the following 3 cells (down)
and different portions in each such cell. What portions? How can the
portions be distinguished? Provide some examples of what you have and what
you want to have. HTH Otto
"dc" wrote in message
...



Reply
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



All times are GMT +1. The time now is 05:06 AM.

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"