Using =FIND("<footer",A3) and filling down, finds <footer in every record. To replace <footer with something else use SUBSTITUTE
Enter in B3 and copy down then copy and Paste Values to get rid of the formula.
Formula:
=SUBSTITUTE(A3,"<footer","your text")
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I suggested that back at Post 3, but the OP seemed t want an alternative solution.Originally Posted by newdoverman
Using =FIND("<footer",A3) and filling down, finds <footer in every record. To replace <footer with something else use SUBSTITUTE
Enter in B3 and copy down then copy and Paste Values to get rid of the formula.
Formula:=SUBSTITUTE(A3,"<footer","your text")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks