formula to remove /

[howard]

I have data in Col D as follows:

Book1
	D
1	Updated on: 05/04/2018 17:08
Fixed assets Recon

Cell Formulas
Range	Formula
D1	="Updated on: "&TEXT(NOW(), "dd/mm/yyyy hh:mm")

I have a formula to extract the month & year

=MID(D1,FIND(":",D1)+6,6)

I need a formula to remove the /


the formula returns 4/2018 based on the data in Col D1 which is currently "Updated on: 05/04/2018 17:08"


It would be appreciated if someone could kindly amend my formula

 

[sheetspread]

=substitute(MID(D1,FIND(":",D1)+6,6),"/","")

?

 

[jproffer]

So you want the 4/2018 to be changed to 42018?

Maybe this?

=REPLACE(A1,FIND("/",A1),1,"")

 

[Scott Huish]

Why don't you just use a different NOW() formula formatted differently?

=TEXT(NOW(),"myyyy")

or just use =NOW() and format the cell as myyyy

 

[howard]

Thanks Scott -will do so