Excel: Data Parse Command Does Not Parse NumbersLast reviewed: November 2, 1994 
The information in this article applies to:
Summary: In Microsoft Excel you cannot parse numbers with the Data Parse command. Data Parse is intended to parse text only. When you attempt to parse a number with the Data Parse command, the data parse line will be blank. More Information: To get the sections of the number you want, use the MID text function. To perform a manual parse, follow the steps below to create a formula that uses the MID function:
This formula will adjust according to the position of the dollar signs in the formula, so be sure the dollar signs are in the correct place. In the example the first three numbers are placed in column B, the next four numbers in column C, and the next three numbers in column D. It yields the following values: A1: # of Chars: B1: 3 C1: 4 D1: 3 A2: run total: B2: 1 C2: 4 D2: 8 A3: 1234567891 B3: 123 C3: 4567 D3: 891 A4: 1235465767 B4: 123 C4: 5465 D4: 767 A5: 1234567865 B5: 123 C5: 4567 D5: 865 A6: 5434232123 B6: 543 C6: 4232 D6: 123 To permanently store the data only:

KBCategory: kbusage Last reviewed: November 2, 1994 