Help with a Concatenate and Substitute formula

[Hypex]

Hi all

I am trying to create a formula which will concatenate certain text and data, but which will also substitute some of the backslashes out into underscores. So, I've got as far as:

=SUBSTITUTE(CONCATENATE("\\servername",A2,".txt"),"\","_")

The issue is that I wish to change the backslashes in cell A2 to underscores, but I need to keep the backslashes in the "\\servername" part. Is there a possibility to do this at all?


Thank you!

[PaulSP8]

Would a simple rejig work for you?

="\\servername"&SUBSTITUTE(A2,"\","_")&".txt"

[Hypex]

Like a charm. Thank you so much!