LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Splitting cell contents into other columns

Hi Gary,

Am Fri, 25 Apr 2014 17:04:30 -0700 (PDT) schrieb gwc:

For each cell in Col A, how do I put:

the beginning characters [up to the first space (" ")] into Col B
the ending characters [after the last space (" ")] into Col C
the other characters into Col D.


please look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "SplitToColumns"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
 
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
Splitting multiple cell contents from 1st column into 4 columns Daphtg Excel Discussion (Misc queries) 3 April 30th 10 02:42 PM
splitting out cell contents ksh Excel Discussion (Misc queries) 2 January 14th 08 06:14 PM
Splitting cell contents GARY Excel Discussion (Misc queries) 1 November 5th 07 06:58 PM
Splitting the contents of a cell? Dan B Excel Worksheet Functions 4 December 8th 05 08:34 PM
Splitting cell contents Jon Atkins Excel Programming 6 September 25th 04 07:31 PM


All times are GMT +1. The time now is 07:15 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"