Next Invoice Coding

[Rabbitiswise70]

I am trying(and i know i have done this before) save the file name with a space between each range. This is what i am running and all the numbers run togather:

NewFN = "C:\Users\garyk\Documents\ATI\CN\2018\CN" & Range("K2").Value & Range("I4").Value & Range("K3") & ".xlsm"

File name looks like this "CN353047d1test2070886.xlsm"

what i would like it to look like is "CN_35304_7D1Test2_070886.xlsm"

How can i get those spaces or dash or something to separate it in there?

 

[sericom]

[B]NewFN = "C:\Users\garyk\Documents\ATI\CN\2018\CN " & Range("[COLOR=#ff0000]K2[/COLOR]").Value & " " & Range("[COLOR=#0000ff]I4[/COLOR]").Value & " " & Range("[COLOR=#00ff00]K3[/COLOR]") & ".xlsm" [/B]

 

[Rabbitiswise70]

Thank you, your the bomb....worked perfectly....