| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
spliting out data in one field into two
Hi, I have a speadsheet where I need to split data out of one field in two
and six fields instead. Here is what I have. 01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. 2004015608 I need to separte out this by the first 4 numbers; into two fields. Is there a forumula that does this? Thanks!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
spliting out data in one field into two
Hi Ginab,
01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. Try: Data | Text to columns | Delimited | Next | Enter a hyphen in the 'Other' option 2004015608 I need to separte out this by the first 4 numbers; into two fields Try: Data | Text to columns | Fixed width | ... --- Regards, Norman "ginab" wrote in message ... Hi, I have a speadsheet where I need to split data out of one field in two and six fields instead. Here is what I have. 01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. 2004015608 I need to separte out this by the first 4 numbers; into two fields. Is there a forumula that does this? Thanks!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
spliting out data in one field into two
So do I need to go in and inset columns then write it one just one of the
columns? Thanks!! "Norman Jones" wrote: Hi Ginab, 01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. Try: Data | Text to columns | Delimited | Next | Enter a hyphen in the 'Other' option 2004015608 I need to separte out this by the first 4 numbers; into two fields Try: Data | Text to columns | Fixed width | ... --- Regards, Norman "ginab" wrote in message ... Hi, I have a speadsheet where I need to split data out of one field in two and six fields instead. Here is what I have. 01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. 2004015608 I need to separte out this by the first 4 numbers; into two fields. Is there a forumula that does this? Thanks!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
spliting out data in one field into two
I got it. Thanks!!!
"ginab" wrote: So do I need to go in and inset columns then write it one just one of the columns? Thanks!! "Norman Jones" wrote: Hi Ginab, 01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. Try: Data | Text to columns | Delimited | Next | Enter a hyphen in the 'Other' option 2004015608 I need to separte out this by the first 4 numbers; into two fields Try: Data | Text to columns | Fixed width | ... --- Regards, Norman "ginab" wrote in message ... Hi, I have a speadsheet where I need to split data out of one field in two and six fields instead. Here is what I have. 01-02-400-003-000 I need to split these out into 5 different fields by the hyphen. 2004015608 I need to separte out this by the first 4 numbers; into two fields. Is there a forumula that does this? Thanks!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spliting 1 Text field into 3 | Excel Discussion (Misc queries) | |||
| Spliting data | Excel Discussion (Misc queries) | |||
| help with spliting data cells | New Users to Excel | |||
| Reduce a value by spliting the data | Excel Programming | |||
| spliting a column of data into multiple columns | Excel Discussion (Misc queries) | |||
Linear Mode
