naming a report using replace

[rjmdc]

original file name
Expense Report lastname_firstname__ID Number_11-2024(Report Date 11.21.2024).xlsx
i need the new report based off this one to be a rename:
one attachment is called: Attachment2 = Replace(Attachment1, ".xlsx", ".pdf")
i now also need an attachment
replace BOTH the words "Expense Rport " with "Monthly Expense Report" and (Attachment1, ".xlsx", ".pdf")

how can i do that in one expression
thanks

 

[Micron]

Some specific examples would help to make it clearer. I think your solution is to nest Replace functions.
If the str = "dog cat fish bird" you could remove cat and fish with
Replace(Replace("dog cat fish bird"," cat","")," fish","")
If you want to replace a string with a string then your replacement string would be that string and not "".
HTH

 

[rjmdc]

hi
i am sorry
can you use my file name and show me how you would do the nested reaplace:
Expense Report lastname_firstname__ID Number_11-2024(Report Date 11.21.2024).xlsx
I need the .xlsx replaced with PDF
and the words Expense report replaced with Monthly Expenses
thanks

 

[Micron]

I'm assuming this is for use in vba code? Then wanting it done in one line doesn't really make sense unless it's just a learning exercise.
Replace(Replace("Expense Report lastname_firstname__ID Number_11-2024(Report Date 11.21.2024).xlsx","Expense Report","Monthly Expenses"),"xlsx","pdf")

The expression in code would be a lot shorter if the original string was assigned to a variable:

Dim strReportName As String

strReportName = "Expense Report lastname_firstname__ID Number_11-2024(Report Date 11.21.2024).xlsx"
strReportName = Replace(Replace(strReportName,"Expense Report","Monthly Expenses"),"xlsx","pdf")

and even shorter if the Find and Replace strings were assigned to variables. However, the code itself would be longer - a small price to pay for being easier to read and follow.