| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate a FirstLast text string into two columns | Excel Discussion (Misc queries) | |||
| List File Properties - Author | Excel Worksheet Functions | |||
| Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
| Splitting a concatenated string into separate rows... | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
