Hello,
I have a reference in my workbook that I no longer need starting by F (+6 number) and I (+5 number) following by :
example: I12345: F123456:
In the cell A1 I have the following text:
A1 = "I12345: Formal Data - Reports or SQL data purchase"
C1 = "F178456: PROC Performance
F178457: PROC System testing
F178458: PROC testing
My goal is to get
A1 = "Formal Data - Reports or SQL data purchase"
C1 = "PROC Performance
PROC System testing
PROC testing
Would you know if a formula can do that? I have tried with =REPLACE(A1;1;8;"") but I could only remove the references at the beginning of the cell. Which is not what I want.
EG: C1 = "PROC Performance
F178457: PROC System testing
F178458: PROC testing"
You may have a better formula
Many thanks in advance,
Graig
Bookmarks