Splitting cell contents into other columns
 

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.

Here is a sample of my spreadsheet:

A
3ABN Three Angels Broadcasting Network 9393
ABCF ABC Family 180
AHC American Heroes Channel 195
BET BET 124
BIO Bio 119
KCAL IND 9
KCBS CBS 2
KCET PBS 28
KOCE PBS 50
KTLA CW 5
KTTV FOX 11
SIRIUS Elvis Radio 6013
SIRIUS Escape 6076
SIRIUS E-Street Radio 6010
SUND Sundance TV 358
SYFY Syfy 122
TBN TBN 260
TBS TBS 139
TCM Turner Classic Movies 132

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