Need insert a dash in between last 4 digits in text string

If the text is in A1 then enter the following formula in B1
=Mid(A1,7,2) & "-" & Mid(A1,9,2)
Alok

"Phil" wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

Thanks. It worked great.

"Alok" wrote:

> If the text is in A1 then enter the following formula in B1
> =Mid(A1,7,2) & "-" & Mid(A1,9,2)
> Alok
>
> "Phil" wrote:
>
> > I have a column (TractID) that has a 10 character text string, like the
> > following entry: 0190003164.
> >
> > First, I need to grab the last four digits (3164) of the entry, copy them to
> > the next column (PropertyID), then insert a dash (-) between the 3rd to last
> > (from the R) and the 2nd to last characters.
> >
> > The data in the column will always be the same format, if that helps.
> >
> > How do I do this?

One way:

=MID(A1,7,2) & "-" & RIGHT(A1,2)

another:

=TEXT(RIGHT(A1,4),"00-00")

In article <[email protected]>,
"Phil" <[email protected]> wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

If the text is in A1 then enter the following formula in B1
=Mid(A1,7,2) & "-" & Mid(A1,9,2)
Alok

"Phil" wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

Thanks. It worked great.

"Alok" wrote:

> If the text is in A1 then enter the following formula in B1
> =Mid(A1,7,2) & "-" & Mid(A1,9,2)
> Alok
>
> "Phil" wrote:
>
> > I have a column (TractID) that has a 10 character text string, like the
> > following entry: 0190003164.
> >
> > First, I need to grab the last four digits (3164) of the entry, copy them to
> > the next column (PropertyID), then insert a dash (-) between the 3rd to last
> > (from the R) and the 2nd to last characters.
> >
> > The data in the column will always be the same format, if that helps.
> >
> > How do I do this?

One way:

=MID(A1,7,2) & "-" & RIGHT(A1,2)

another:

=TEXT(RIGHT(A1,4),"00-00")

In article <[email protected]>,
"Phil" <[email protected]> wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

Thanks. It worked great.

"Alok" wrote:

> If the text is in A1 then enter the following formula in B1
> =Mid(A1,7,2) & "-" & Mid(A1,9,2)
> Alok
>
> "Phil" wrote:
>
> > I have a column (TractID) that has a 10 character text string, like the
> > following entry: 0190003164.
> >
> > First, I need to grab the last four digits (3164) of the entry, copy them to
> > the next column (PropertyID), then insert a dash (-) between the 3rd to last
> > (from the R) and the 2nd to last characters.
> >
> > The data in the column will always be the same format, if that helps.
> >
> > How do I do this?

One way:

=MID(A1,7,2) & "-" & RIGHT(A1,2)

another:

=TEXT(RIGHT(A1,4),"00-00")

In article <[email protected]>,
"Phil" <[email protected]> wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

If the text is in A1 then enter the following formula in B1
=Mid(A1,7,2) & "-" & Mid(A1,9,2)
Alok

"Phil" wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

One way:

=MID(A1,7,2) & "-" & RIGHT(A1,2)

another:

=TEXT(RIGHT(A1,4),"00-00")

In article <[email protected]>,
"Phil" <[email protected]> wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

Thanks. It worked great.

"Alok" wrote:

> If the text is in A1 then enter the following formula in B1
> =Mid(A1,7,2) & "-" & Mid(A1,9,2)
> Alok
>
> "Phil" wrote:
>
> > I have a column (TractID) that has a 10 character text string, like the
> > following entry: 0190003164.
> >
> > First, I need to grab the last four digits (3164) of the entry, copy them to
> > the next column (PropertyID), then insert a dash (-) between the 3rd to last
> > (from the R) and the 2nd to last characters.
> >
> > The data in the column will always be the same format, if that helps.
> >
> > How do I do this?

If the text is in A1 then enter the following formula in B1
=Mid(A1,7,2) & "-" & Mid(A1,9,2)
Alok

"Phil" wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

One way:

=MID(A1,7,2) & "-" & RIGHT(A1,2)

another:

=TEXT(RIGHT(A1,4),"00-00")

In article <[email protected]>,
"Phil" <[email protected]> wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

Thanks. It worked great.

"Alok" wrote:

> If the text is in A1 then enter the following formula in B1
> =Mid(A1,7,2) & "-" & Mid(A1,9,2)
> Alok
>
> "Phil" wrote:
>
> > I have a column (TractID) that has a 10 character text string, like the
> > following entry: 0190003164.
> >
> > First, I need to grab the last four digits (3164) of the entry, copy them to
> > the next column (PropertyID), then insert a dash (-) between the 3rd to last
> > (from the R) and the 2nd to last characters.
> >
> > The data in the column will always be the same format, if that helps.
> >
> > How do I do this?

If the text is in A1 then enter the following formula in B1
=Mid(A1,7,2) & "-" & Mid(A1,9,2)
Alok

"Phil" wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

One way:

=MID(A1,7,2) & "-" & RIGHT(A1,2)

another:

=TEXT(RIGHT(A1,4),"00-00")

In article <[email protected]>,
"Phil" <[email protected]> wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

Thanks. It worked great.

"Alok" wrote:

> If the text is in A1 then enter the following formula in B1
> =Mid(A1,7,2) & "-" & Mid(A1,9,2)
> Alok
>
> "Phil" wrote:
>
> > I have a column (TractID) that has a 10 character text string, like the
> > following entry: 0190003164.
> >
> > First, I need to grab the last four digits (3164) of the entry, copy them to
> > the next column (PropertyID), then insert a dash (-) between the 3rd to last
> > (from the R) and the 2nd to last characters.
> >
> > The data in the column will always be the same format, if that helps.
> >
> > How do I do this?

If the text is in A1 then enter the following formula in B1
=Mid(A1,7,2) & "-" & Mid(A1,9,2)
Alok

"Phil" wrote:

> I have a column (TractID) that has a 10 character text string, like the
> following entry: 0190003164.
>
> First, I need to grab the last four digits (3164) of the entry, copy them to
> the next column (PropertyID), then insert a dash (-) between the 3rd to last
> (from the R) and the 2nd to last characters.
>
> The data in the column will always be the same format, if that helps.
>
> How do I do this?

I have a column (TractID) that has a 10 character text string, like the
following entry: 0190003164.

First, I need to grab the last four digits (3164) of the entry, copy them to
the next column (PropertyID), then insert a dash (-) between the 3rd to last
(from the R) and the 2nd to last characters.

The data in the column will always be the same format, if that helps.

How do I do this?