Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
taking data from multiple cells and displaying in one cell | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) |