Inserting Dashes in a Column

[cbanks]

12356789 in column a1

I want to put in column a2 123-567-89

Whats the formula to put dashed in between the numbers without havin to
retype 20000 numbers.

Thanks

[PCLIVE]

Try changing the format for your cells. Select your cells. Right-click on
them and select Format Cells. Under Category, select Custom. Type the
following:

###-###-##

Hope this helps,
Paul

"cbanks" <[email protected]> wrote in message
news:[email protected]...
> 12356789 in column a1
>
> I want to put in column a2 123-567-89
>
> Whats the formula to put dashed in between the numbers without havin to
> retype 20000 numbers.
>
> Thanks
>
>

[Fred Smith]

If you actually want the dashes stored in a cell, the formula would look like:

=left(a1,3)&"-"&mid(a1,4,3)&"-"&right(a1,2)

--
Regards,
Fred


"PCLIVE" <[email protected]> wrote in message
news:[email protected]...
> Try changing the format for your cells. Select your cells. Right-click on
> them and select Format Cells. Under Category, select Custom. Type the
> following:
>
> ###-###-##
>
> Hope this helps,
> Paul
>
> "cbanks" <[email protected]> wrote in message
> news:[email protected]...
>> 12356789 in column a1
>>
>> I want to put in column a2 123-567-89
>>
>> Whats the formula to put dashed in between the numbers without havin to
>> retype 20000 numbers.
>>
>> Thanks
>>
>>
>
>

[bigwheel]

You need to format the cell. Click Format>Cell>Number>Custom then under Type
create your format thus:- 000-000-00

"cbanks" wrote:

> 12356789 in column a1
>
> I want to put in column a2 123-567-89
>
> Whats the formula to put dashed in between the numbers without havin to
> retype 20000 numbers.
>
> Thanks
>
>