This is a very simple requirement. Can anyone help me with this ASAP.
What i need:- Insert "-" in text "1234567890" to have a output like
this"123-456-7890"
Thanks in advance!!!
Regards,
Alwyn
This is a very simple requirement. Can anyone help me with this ASAP.
What i need:- Insert "-" in text "1234567890" to have a output like
this"123-456-7890"
Thanks in advance!!!
Regards,
Alwyn
Change the format of the cells to "Custom" and enter 000-000-0000
"Alwyn" wrote:
> This is a very simple requirement. Can anyone help me with this ASAP.
>
> What i need:- Insert "-" in text "1234567890" to have a output like
> this"123-456-7890"
>
> Thanks in advance!!!
>
> Regards,
>
> Alwyn
>
>
That is the easiest solution to change the output of the cells. If you want
to actually change the content of the cells you will need to create a dummy
column and use the formula
=LEFT(A1,3)&"-"&MID(A1,3,3)&"-"&RIGHT(A1,4)
After copying this formula down the list, you can then copy the column and
paste special selecting "values".
"Elkar" wrote:
> Change the format of the cells to "Custom" and enter 000-000-0000
>
> "Alwyn" wrote:
>
> > This is a very simple requirement. Can anyone help me with this ASAP.
> >
> > What i need:- Insert "-" in text "1234567890" to have a output like
> > this"123-456-7890"
> >
> > Thanks in advance!!!
> >
> > Regards,
> >
> > Alwyn
> >
> >
On 25 Oct 2005 14:22:49 -0700, "Alwyn" <alwynrozario@gmail.com> wrote:
>This is a very simple requirement. Can anyone help me with this ASAP.
>
>What i need:- Insert "-" in text "1234567890" to have a output like
>this"123-456-7890"
>
>Thanks in advance!!!
>
>Regards,
>
>Alwyn
=TEXT(1234567890,"000-000-0000")
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks