Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by MARSPATH
at 2024-05-23 14:32:35
ModifyPoint:500 Replies:3 POST_ID:828918USER_ID:11819
Topic:
Spreadsheet Software;;
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.
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.
Expert: duncanb7 replied at 2024-05-24 17:21:07
Thanks for your points
Have a nice day
Duncan
Have a nice day
Duncan
Author: MARSPATH replied at 2024-05-24 14:25:43
Got me started in the right direction, thanks
Accepted Solution
Expert: duncanb7 replied at 2024-05-23 16:45:18
500 points EXCELLENT
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
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
