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

"David Billigmeier" wrote:

=SUBSTITUTE(A1,"P -","F -")

--
Regards,
Dave


"Á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