Seperate data
in [General]
|
From: JJ on 21 Apr 2010 03:08 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
From: Jacob Skaria on 21 Apr 2010 03:19 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
From: JJ on 21 Apr 2010 03:25 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
From: JJ on 21 Apr 2010 03:45 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
From: Jacob Skaria on 21 Apr 2010 04:49 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
|
Next
|
Last
Pages: 1 2 Prev: Problem with subsets for multiple Report Filters in 2007 PivotTabl Next: Unusual Date Format |