Two step calculation...?

[wpryan]

Hi there, I have some text in a cell that I need to modify. The text is am imported file name

RotatorTestLogFile0_2023_01_09_14_47_35.txt

I need to change it, the "ultimate state" will be a text string

RotTestLog_20230109144735

I found that If I make a two step calculation I can get it close to where I want to be. Step 1:

=SUBSTITUTE(C5;"_";"")

Step 2:

="RotTestLog_"&MID(G6;20;14)

...can this be consolidated into one step?

 

[Fluff]

How about

="RotTestLog_"&MID(SUBSTITUTE(C5,"_",""),20,14)

 

[wpryan]

How about

="RotTestLog_"&MID(SUBSTITUTE(C5,"_",""),20,14)

That works, thanks!

 

[Fluff]

You're welcome & thanks for the feedback.