Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find & Replace text format | Excel Discussion (Misc queries) | |||
How to replace a text with another | Excel Worksheet Functions | |||
If function with text | New Users to Excel | |||
If function with text | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions |