Anybody know how to format the following?

Hi,

I need to either format the following so that each will left justify OR be able to insert the two columns into tables. As I have 27,000 entries, copying and pasting into tables is ruled out. Any way to automate it?

Thanks.

Velvet Green Jethro Tull
Waethercock Jethro Tull
War Child Jethro Tull
Warm Sporran Jethro Tull
Watching Me, Watching You Jethro Tull
We Used To Know Jethro Tull
White Innocence Jethro Tull
Wind-Up Jethro Tull
With You There To Help Me Jethro Tull
Wond'ring Again Jethro Tull
Wond'ring Aloud Jethro Tull
Working John, Working Joe Jethro Tull
Cross My Broken Heart Jets
Crush On You Jets
Rocket 2 U Jets
Same Love Jets
French Song Jett, Joan & The Blackhearts
I Love Rock 'N' Roll Jett, Joan & The Blackhearts
Sky High Jigsaw
Bertha Butt Boogie (Part I) Jimmy Castor Bunch
Troglodyte (Cave Man) Jimmy Castor Bunch
Tantalise Jimmy The Hoover
Closer Every Day Jitters
Run Run Run Jo Jo Gunne
Just Got Lucky Joboxers
My Pledge Of Love Joe Jeffrey Group
A Matter Of Trust Joel, Billy
Allentown Joel, Billy
An Innocent Man Joel, Billy
Baby Grand Joel, Billy
Big Man On Mulberry Street Joel, Billy
Careless Talk Joel, Billy
Christie Lee Joel, Billy
Code Of Silence Joel, Billy
Easy Money Joel, Billy
Getting Closer Joel, Billy
Keeping The Faith Joel, Billy
Leave A Tender Moment Alone Joel, Billy
Longest Time Joel, Billy
Modern Woman Joel, Billy
Movin' Out Joel, Billy
My Life Joel, Billy
Night Is Still Young Joel, Billy
Pressure Joel, Billy
Running On Ice Joel, Billy
She's Always A Woman Joel, Billy
Tell Her About It Joel, Billy
Temptation Joel, Billy
The Entertainer Joel, Billy
This Is The Time Joel, Billy
This Night Joel, Billy
Uptown Girl Joel, Billy
We Didn't Start The Fire Joel, Billy
You're Only Human Joel, Billy
Baby Grand Joel, Billy/Ray Charles
Night After Day Joel, Billy/The Hassles
All The Nasties John, Elton
Bennie And The Jets John, Elton
Bitch Is Back John, Elton
Blue Eyes John, Elton

 

i assume the BBS did a fine job of left justifying your data for you

Tricks to mess with formatting of wierd whitespace
you can paste it into word,
Search and Replace "<space><space>" with <space>. This will melt down whitespace.
replace "<Paragraph><space>" with <paragraph>. (use more->'special' Paragraph mark or just ^p)
That should give you a normalized list. Then do whatever it is you want to do with it.

 

It sure did a fine job LOL

I am going to try that. Thanks, Joe.