| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Replace &F in header with text
Hey Dave! Yep, you got it. (I just got to read your last post) Scenario, over four hundred excel workbooks, right header is coded DOC. NO. &F I need to replace &F with the actual file name, as text Example 5098000.xls right header reads DOC. NO. &F Need to change to read DOC. NO. 5098000.xls If I can get something that will run on the contents of a specified folder, that would be great! I'll take whatever I can get though!! Thanks again!! Michelle ;) -- amthyst826 ------------------------------------------------------------------------ amthyst826's Profile: http://www.excelforum.com/member.php...o&userid=28308 View this thread: http://www.excelforum.com/showthread...hreadid=478853 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrap Text | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Macro to delete and replace a text box | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Threaded Mode
