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

"Miguel Zapico" wrote:

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

Hope this helps,
Miguel.

"Álvaro" wrote:

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