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

 Page 1 of 1 [ 3 post ]

Relevant Pages