| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate data
I need help please. How do I go about to seperate data in one cell ex:
A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want to seperate cell A1, 1------from 2-b0-40810 and cell A2, 2------from 1-03-0060. Tx |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate data
1-------2-b0-40810
The hyphen between 1 and the second piece; represent real hyphen or some other text values..Could you post the actual data or confirm whether the samples posted are the real ones. -- Jacob (MVP - Excel) "JJ" wrote: I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want to seperate cell A1, 1------from 2-b0-40810 and cell A2, 2------from 1-03-0060. Tx |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate data
Jacob
this is the actual data. you will see from the data that the second piece of info is not all in line. tx. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate data
The length of data of the second section is not all the same. Some are 9
characters long and others are 11 characters long. Tx. "JJ" wrote: Jacob this is the actual data. you will see from the data that the second piece of info is not all in line. tx. "Jacob Skaria" wrote: 1-------2-b0-40810 The hyphen between 1 and the second piece; represent real hyphen or some other text values..Could you post the actual data or confirm whether the samples posted are the real ones. -- Jacob (MVP - Excel) "JJ" wrote: I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want to seperate cell A1, 1------from 2-b0-40810 and cell A2, 2------from 1-03-0060. Tx |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate data
With data in A1
In B1 =LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},MID(A1, FIND("-",A1),255)&"0123456789"))+FIND("-",A1)-2) In C1 =MID(A1,LEN(B1)+1,255) -- Jacob (MVP - Excel) "JJ" wrote: The length of data of the second section is not all the same. Some are 9 characters long and others are 11 characters long. Tx. "JJ" wrote: Jacob this is the actual data. you will see from the data that the second piece of info is not all in line. tx. "Jacob Skaria" wrote: 1-------2-b0-40810 The hyphen between 1 and the second piece; represent real hyphen or some other text values..Could you post the actual data or confirm whether the samples posted are the real ones. -- Jacob (MVP - Excel) "JJ" wrote: I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want to seperate cell A1, 1------from 2-b0-40810 and cell A2, 2------from 1-03-0060. Tx |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate data
hi Jacob
I tried it and it works great. Tx, appreciate your assistance. "Jacob Skaria" wrote: With data in A1 In B1 =LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},MID(A1, FIND("-",A1),255)&"0123456789"))+FIND("-",A1)-2) In C1 =MID(A1,LEN(B1)+1,255) -- Jacob (MVP - Excel) "JJ" wrote: The length of data of the second section is not all the same. Some are 9 characters long and others are 11 characters long. Tx. "JJ" wrote: Jacob this is the actual data. you will see from the data that the second piece of info is not all in line. tx. "Jacob Skaria" wrote: 1-------2-b0-40810 The hyphen between 1 and the second piece; represent real hyphen or some other text values..Could you post the actual data or confirm whether the samples posted are the real ones. -- Jacob (MVP - Excel) "JJ" wrote: I need help please. How do I go about to seperate data in one cell ex: A1 1-------2-b0-40810 A2 2-----------1-03-0060 I typically want to seperate cell A1, 1------from 2-b0-40810 and cell A2, 2------from 1-03-0060. Tx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
| How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Linear Mode
