Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet that refers to a bundle of web tables from a website. I
want to be able to mass replace the links on my spreadsheet so that a portion of the web address being references gets changed eg. Current address http://xxx.yyy.com/Leaderboard_State...terID=4&Page=1 I want to change all references to &SeasonQuarterID=4 to &SeasonQuarterID=5 Doing this one sheet at a time is extremely time consuming. A solution would be fantastic! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
External Data Query | Excel Discussion (Misc queries) | |||
Get External Data-New Web Query | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Import External Data/New WEB Query | Excel Discussion (Misc queries) | |||
Query of External Data | Excel Discussion (Misc queries) |