splitting 3-digit field into a 2-digit and a 1-digit field 
Author Message
 splitting 3-digit field into a 2-digit and a 1-digit field

Hi!

I have excel 2000 and a 3-digit field. I want to split
this field into two separate fields or columns. One field
would be the first two digits and the other field would
be the last digit.

The original 3-digit field is numerical and I need to
preserve leading zeros. So the number 012 would look like
01 in one column and 2 in the other.

Thanks,
Danno



Sat, 24 Sep 2005 02:02:05 GMT  
 splitting 3-digit field into a 2-digit and a 1-digit field
Select the cells with the 3-digits; Use Data/Text to Colulmns, select Fixed
Width, then click Next, then click between the 2nd & 3rd digits, then click
finish. Select the column with the 2-digits, and format them as "00"

Bob Umlas
Excel MVP


Quote:
> Hi!

> I have excel 2000 and a 3-digit field. I want to split
> this field into two separate fields or columns. One field
> would be the first two digits and the other field would
> be the last digit.

> The original 3-digit field is numerical and I need to
> preserve leading zeros. So the number 012 would look like
> 01 in one column and 2 in the other.

> Thanks,
> Danno



Sat, 24 Sep 2005 02:51:26 GMT  
 splitting 3-digit field into a 2-digit and a 1-digit field
Thanks, Bob!

But I forgot to mention I have leading zeros I want
preserved. So '123' would easily split into 12 and 3. But
010 splits into 10 and blank, using your formula.

How can I make it split into 01 and 0?

Cheers,
Dan

Quote:
>-----Original Message-----
>Select the cells with the 3-digits; Use Data/Text to

Colulmns, select Fixed
Quote:
>Width, then click Next, then click between the 2nd & 3rd
digits, then click
>finish. Select the column with the 2-digits, and format
them as "00"

>Bob Umlas
>Excel MVP



>> Hi!

>> I have excel 2000 and a 3-digit field. I want to split
>> this field into two separate fields or columns. One
field
>> would be the first two digits and the other field would
>> be the last digit.

>> The original 3-digit field is numerical and I need to
>> preserve leading zeros. So the number 012 would look
like
>> 01 in one column and 2 in the other.

>> Thanks,
>> Danno

>.



Sat, 24 Sep 2005 12:07:13 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. 4-digits split into 2 cols (with 2 digits each)

2. 2 digit year to 4 digit year

3. Date conversion from 2 digit year to 4 digit

4. select a specific digit in a 9 digit number

5. Consolidate 2 rows of digits into a single digit

6. Selecting 2 digits of 7 digit number??

7. Converting a 2 digit year to 4 digit year

8. Changing 5 digit number to 3 digit number

9. 11 digit key instead of 17 digit ?????

10. converting a 20 digit product ID number into a 23 digit number


 
Powered by phpBB® Forum Software © phpBB Group