How to find and replace with regex in excel -
i have excel file 1 column , multiple rows. the rows contain various text, here's example: texts home texts whatever dafds dgretwer werweerqwr texts 21412 texts 346345 texts rwefdg terfesfasd rwerw i want replace "texts *" * after "texts are" specific word, example "texts replaced". how can in excel? as alternative regex, running: sub replacer() dim n long, long n = cells(rows.count, "a").end(xlup).row = 1 n if left(cells(i, "a").value, 9) = "texts are" cells(i, "a").value = "texts replaced" end if next end sub will produce: