| 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!!! |
| 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) | |||
Threaded Mode
