新聞財經娛樂♬資訊 News Economy

Excel 2007 .xlsx file cells A4 through A72 contains as part of string 'E:SitesLee Academy for the Arts'

I want to replace' E:SitesLee Academy for the Arts' with 'http://schoolforthearts.org/'

How do I get this to work? e.g.

replace (A1...A71, "E:SitesLee Academy for the Arts", "http://schoolforthearts.org/") - this does not work in f(x) cell.

You may need to do it in VBA on Excel for range operation from a1:a100

If in Excel cell operation, try this and need to drag the cell from A1 to A100 on Excel sheet
and using find() and if() function

A1                                      B1
========================================
E:SitesLee Academy   =if(ISERROR(find("E:SitesLeeAcademy",A1,1))=TRUE,"","http://schoolforthearts.org/","")

Duncan