Re: in a column of numb's and names, put the numb's in other colum
- From: SteveW <sj_walton@xxxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 03:43:07 +0100
Glad it worked, thanks for the feedback
Steve
On Tue, 29 Aug 2006 20:39:03 +0100, Oswin <Oswin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hello Steve,.
The first time I tried your suggestion within my file and I believe because
the scanned data file, I had a little problem. After I copied the 2200
record column into a test file, everything worked out just great. I had a
bit of work correcting the data, but it was nothing compared to if I had to
first all the numbers manually and then remove the numbers from the name
column.
I want you to know, I really appreciated your input to my problem!
Thanks again,
Oswin
"SteveW" wrote:
As long as the data is in some consistant format
like number space name
or each number is of a fixed width
The click on the column, Data, Text to Columns...
Then either split the text on space or after a particular column in the
data
Remember it will overwrite the columns to to the right
suggest you add in a couple of blank ones - delete unwanted ones afterwards
Steve
On Tue, 29 Aug 2006 17:23:01 +0100, Oswin
<Oswin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> I have over 2000 lines of a tag # number plus a dog name in one column in
> excel 2003 which I scanned in. Can anyone tell me if I can edit the
> numbers
> into another column automatically??? The entire column in one edit
> operation??? The tag # into another column. Other than re-typing each
> line.
> Thank you in advance for your help,
> Oswin
- References:
- Prev by Date: Re: Adding time HH:MM when it addds up to more than 24 hours
- Next by Date: Re: Adding selected numbe in a column
- Previous by thread: Re: in a column of numb's and names, put the numb's in other colum
- Next by thread: Re: in a column of numb's and names, put the numb's in other colum
- Index(es):
Relevant Pages
|
