Replace function into text

Ã

Ãlvaro

Hi all, I have very long document names listed in column A, which are NOT
coded, and the names of the documents have somewhere in the them the
following text:"P -". the thing is that the amount of characters to the right
or letf is not always the same, and I would like to copy in th B column the
same names but having the "P -" replaced by an "F -". I need this to be a
funcion and not to use the replace command.

Thanks you all for your help
Ãlvaro
 
M

Miguel Zapico

You may use the SUBSTITUTE function, something like:
=SUBSTITUTE(A1,"P -","F -")

Hope this helps,
Miguel.
 
Ã

Ãlvaro

Hi David,thanks so much for your quick response!!!
it worked perfectly!!!!
Saludos
álvaro
 
Ã

Ãlvaro

Hola Miguel , thanks so much for your quick response!!!
it worked perfectly!!!!
Saludos
álvaro
 
Top