Re: split "abc,123"
From: Kyli (anonymous_at_discussions.microsoft.com)
Date: 05/25/04
- Next message: Trevor Shuttleworth: "Re: combining if then & range functions"
- Previous message: Aladin Akyurek: "Re: Replacing #N/A with a value"
- In reply to: JE McGimpsey: "Re: split "abc,123""
- Next in thread: DDM: "Re: split "abc,123""
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 May 2004 13:36:40 -0700
Okay, now I feel stupid. I didn't know that existed up
there. Could I have asked for anything more simple? This
is going to help...A LOT. Thank-you everyone for all your
formulas and help.
Thanks!
>-----Original Message-----
>One way:
>
>Select the cell(s) and choose Data/Text to columns...
>In the first pane, choose Delimited, then click Next
>In the second pane, check the Comma checkbox, then click
Next
>In the third pane, change the Destination address to
column B, then click OK.
>
>In article <1250301c44289$7f595450$a501280a@phx.gbl>,
> "Kyli" <anonymous@discussions.microsoft.com> wrote:
>
>> I need to find a formula to split Column A: "abd,123"
into
>> column B: "abc" and column C: "123".
>>
>> I know there has to be a "mid" function or something
that
>> allows me to pull everything before the comma into one
>> cell and another to pull everything after the comma
into
>> another cell.
>>
>> Please let me know if anybody knows the answer to this.
>>
>> P.S. The file is already created, there are other
columns,
>> and I cannot open the file under deliminated because of
>> the other information. Thanks.
>.
>
- Next message: Trevor Shuttleworth: "Re: combining if then & range functions"
- Previous message: Aladin Akyurek: "Re: Replacing #N/A with a value"
- In reply to: JE McGimpsey: "Re: split "abc,123""
- Next in thread: DDM: "Re: split "abc,123""
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
