[mso] Re: Dividing Contents of an Excel column into 2 columns
- From: "Alejandro Velazquez" <velazqa@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 24 Sep 2003 09:42:00 -0500
Wow!!!, It's magic...... what I used to do to separate data from one column
into two columns, was aplying formulas (left, right), and then converting to
values.
I am very glad being part of this list
(If you notice bad grammar, it's because English is not my native languaje,
I'm from Mexico)
Regards
Alex
>From: "Glenda Wells" >Reply-To: mso@xxxxxxxxxxxxx >To: >Subject: [mso] Re:
Dividing Contents of an Excel column into 2 columns >Date: Wed, 24 Sep 2003
09:23:24 -0400 >>Create as many blank columns to the right of the column in
question so >existing data does not get overwritten. >Highlight the desired
column >Choose Data/Text to Columns from the Menu >Delimited will be marked
by default - Click Next >Choose the most appropriate delimiter from the
available options - Click >Next >Apply appropriate formats to each column
from the available options - >Click Finish >>>>>>-----Original Message-----
>From: Diane Rainaud [mailto:drainaud@xxxxxxxxx]=20 >Sent: Wednesday,
September 24, 2003 9:01 AM >To: mso@xxxxxxxxxxxxx >Subject: [mso] Dividing
Contents of an Excel column into 2 columns >>>I know I've seen this is asked
and answered before, >but can't seem to find it in the archives now, so
>accept my apologies for asking. >>I need to know how to take the contents
ofone Excel >column and split the contents between 2 cells. We have >one
column containing and part number and its >name...we'd like to have the part
number and names in >different columns. >>Any help would be greatly
appreciated. >>Diane >>>__________________________________ >Do you Yahoo!?
>Yahoo! SiteBuilder - Free, easy-to-use web site design software
>http://sitebuilder.yahoo.com
>************************************************************* >You are
receiving this mail because you subscribed to mso@xxxxxxxxxxxxx >or
MicrosoftOffice@xxxxxxxxxxxxxxxx >>To send mail to the group, simply address
it to mso@xxxxxxxxxxxxx >>To Unsubscribe from this group, send an email
to=20>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
>quotes) in the subject line. >>Or, visit the group's homepage and use the
dropdown menu. This will >also allow you to change your email settings to
digest or vacation (no >mail). //www.freelists.org/webpage/mso >>To be
able to use the files section for sharing files with the group, >send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an >invitation
with instructions. Once you are a member of the files group, >you can go
hereto upload/download files: >http://www.smartgroups.com/vault/msofiles
>*************************************************************
>************************************************************* >You are
receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx >>To send mail to the group, simply address
it to mso@xxxxxxxxxxxxx >>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
in the subject line. >>Or, visit the group's homepage and use the dropdown
menu. This will also allow you to change your email settings to digest or
vacation (no mail). >//www.freelists.org/webpage/mso >>To be able to
usethe files section for sharing files with the group, send a request to
mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files: >http://www.smartgroups.com/vault/msofiles
>*************************************************************
----------------------------------------------------------------------------
Charla con tus amigos en línea mediante MSN Messenger: Haz clic aquí [1]with
MSN 8.
--- Links ---
1 http://g.msn.com/8HMAESMX/2734??PS=
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
