Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to Columns Code
I need to write code for Text to Columns for the cells I select and they
would always be in the same column, but could be any column. Each cell contains one or more underscores, but I need it split up at the second underscore. I don't have a clue on how to write this, can you help? Example starting with would be: First-Set-Of-Words_SecondSet_ThirdSet I need: First Column Second Column First-Set-Of-Words_SecondSet ThirdSet I need this split between the second and third set dropping the second underscore too and to remain as text format. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help in code Steve G wrote to move data from 4 columns to 21 columns | Excel Programming | |||
Slow code when used as VBA code instead of macro (copying visible columns) | Excel Programming | |||
Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | Excel Programming | |||
Linking text columns with text and data columns | Excel Worksheet Functions | |||
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming |