You're welcome, happy to be of help

Vaya con Dios,
Chuck, CABGx3



"Steve" wrote:

Thanks much. So simple.

Steve

"CLR" wrote:

Check out Data TextToColumns Delimited , using a space as the
delimiter.....

Practice with a copy of your file first...

Vaya con Dios,
Chuck, CABGx3



"Steve" wrote:

I'm copying nfl.com's schedule to an Excel file.
It places , e.g.,
Miami at Pittsburgh in column A
8:30 PM in column B
What I'd like to have is:
Miami in column A
at in column B
Pittsburgh in column C
( I don't need a time column)
How can that be done ?
The 'at' would be the only constant, but the # of characters on either side
of the at will always be different (San Francisco, Denver, New York Jets, etc)

Thanks,