Separate a String of #'s
 

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?

Separate a String of #'s
 

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?

Separate a String of #'s
 

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?

Separate a String of #'s
 

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?

Separate a String of #'s
 

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?