I have a column of #'s which are all somewhat similar. They are
X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
I would like ONLY the 3rd string of #'s. Any easy way?
I have a column of #'s which are all somewhat similar. They are
X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
I would like ONLY the 3rd string of #'s. Any easy way?
Please try mid(your_string, 10,3).
"Coal Miner" wrote:
> I have a column of #'s which are all somewhat similar. They are
> X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
> I would like ONLY the 3rd string of #'s. Any easy way?
Perfect. Thank you.
"ViestaWu" wrote:
> Please try mid(your_string, 10,3).
>
> "Coal Miner" wrote:
>
> > I have a column of #'s which are all somewhat similar. They are
> > X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
> > I would like ONLY the 3rd string of #'s. Any easy way?
Another way would be to copy your column a over to column B and do Data >
TextToColumns on column B using hyphen as delimiter and choosing not to
import the columns not wanted........column B wil result in only your digits
of interest...
Vaya con Dios,
Chuck, CABGx3
"Coal Miner" wrote:
> I have a column of #'s which are all somewhat similar. They are
> X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
> I would like ONLY the 3rd string of #'s. Any easy way?
Cool!!! I had been messing with the textocolumns but did not see the do not
import box. Pretty handy! Thanks for your help also.
"CLR" wrote:
> Another way would be to copy your column a over to column B and do Data >
> TextToColumns on column B using hyphen as delimiter and choosing not to
> import the columns not wanted........column B wil result in only your digits
> of interest...
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Coal Miner" wrote:
>
> > I have a column of #'s which are all somewhat similar. They are
> > X-##-###-###-##-###-###. Let's say these #'s are in column A. In column B,
> > I would like ONLY the 3rd string of #'s. Any easy way?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks