Nosstech
08-01-2008, 08:06 AM
Is there a way to seperate a text string into different cells?
Below is an example that I have. All the data is dumped into Col. A
***EXAMPLE***
Country Radio Aug 08-01-sugarland-all i want to do
Country Radio Aug 08-02-george strait-troubadour (album version)
Country Radio Aug 08-03-rascal flatts-bob that head
Country Radio Aug 08-04-jessica simpson-come on over
Country Radio Aug 08-05-toby keith-she never cried in front of me
***RESULT DESIRED - I want the Album, track, artist and song title to be in different columns***
* | = column break
Country Radio Aug 08 | 01 | sugarland | all i want to do
Country Radio Aug 08 | 02 | george strait | troubadour (album version)
Country Radio Aug 08 | 03 | rascal flatts | bob that head
Country Radio Aug 08 | 04 | jessica simpson | come on over
Country Radio Aug 08 | 05 | toby keith | she never cried in front of me
Below is an example that I have. All the data is dumped into Col. A
***EXAMPLE***
Country Radio Aug 08-01-sugarland-all i want to do
Country Radio Aug 08-02-george strait-troubadour (album version)
Country Radio Aug 08-03-rascal flatts-bob that head
Country Radio Aug 08-04-jessica simpson-come on over
Country Radio Aug 08-05-toby keith-she never cried in front of me
***RESULT DESIRED - I want the Album, track, artist and song title to be in different columns***
* | = column break
Country Radio Aug 08 | 01 | sugarland | all i want to do
Country Radio Aug 08 | 02 | george strait | troubadour (album version)
Country Radio Aug 08 | 03 | rascal flatts | bob that head
Country Radio Aug 08 | 04 | jessica simpson | come on over
Country Radio Aug 08 | 05 | toby keith | she never cried in front of me