Re: new columns created from " "

Giganews Newsgroups
Subject: Re: new columns created from " "
Posted by:  Dave Peterson (ec357…@msn.com)
Date: Tue, 25 May 2004

A non-macro approach.

Edit|replace
replace   
with    , (comma--or some other unique unused character)
replace all

Then select the column and do:
data|text to columns.
delimited
specify that unique character

Greg Wilker wrote:
>
> I have a bunch of data in a column and it is "separated" by " ".
>
> The data was imported from an online database.
>
> Is there a way to create columns within the current workbook from where the
>   appears? (much like importing a text file)
>
> TIA,
> Greg

--

Dave Peterson
ec357…@msn.com

Replies

None

In response to

new columns created from " " posted by Greg Wilker on Tue, 25 May 2004