| Home > Forum Home > Automating Data Analysis Tasks > Change text based on content > FIND and REPLACE functions | Share |
FIND and REPLACE functions
Excel Help for Find And Replace Functions in Automating Data Analysis Tasks
| Forum Topic | Login |
Find And Replace Functions | Rate this: (3/5 from 1 vote) |
 | You do not need a macro to do this. For illustration purposes lets assume that the column of data starts at cell B5. If you want to completely replace the the text with the new one you can make a test using the FIND function: =IF(ISERROR(FIND("[email protected]",B5,1)),B5,"[email protected]") If you want to keep the first 26 characters and just replace the email address text, you can use the REPLACE function: =REPLACE(B5,26,LEN(B5)-26,"[email protected]") The formula can then be copied down for the rest of the rows to return the new text strings. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for FIND and REPLACE functions in the Excel Business Solutions Directory |