Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text To Columns Function
Is it possible to use this funtion to parse data that contatins 2 delimiters :
" \ " and " = " If not is there a way to do this via a formula ? Thank you in advance. |
#2
|
|||
|
|||
Two methods
1. Carry out the conversion once using Other delimiter set to \. This will give 2 columns of data. Chose column 2 and repeat process using Other delimiter set to = 2. Do a search and replace of "=" with "\" first, then do the data to text conversion in one hit. -- Regards Roger Govier "carl" wrote in message ... Is it possible to use this funtion to parse data that contatins 2 delimiters : " \ " and " = " If not is there a way to do this via a formula ? Thank you in advance. |
#3
|
|||
|
|||
You can run it twice, and each time select where (which column) the data
should be placed. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "carl" wrote in message ... Is it possible to use this funtion to parse data that contatins 2 delimiters : " \ " and " = " If not is there a way to do this via a formula ? Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TEXT TO COLUMNS WITH LEADING ZEROS | Excel Discussion (Misc queries) | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
nested function to add columns | Excel Worksheet Functions | |||
Excel IF function for text | Excel Worksheet Functions | |||
Why text to columns is not available when there is mulipule line . | Excel Worksheet Functions |