I have data in Col D as follows:
Book1D1Updated on: 05/04/2018 17:08Fixed assets ReconCell FormulasCellFormulaD1="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...