modify a value

[LorenzoCapocci1]

Hi Team,
I have the following value 00.00.00 in the same cell, and I need to modify it to 00  00  00 .

1st Value 00.00.00 (decision stage to check if it is equal and containing the "." within each number
2nd if it is equal it needs to be modified to "00  00  00"


Can you please help?
Thank you

[LorenzoCapocci1]

Hi Team, seems I found an option that works out

please let me know if there is a better way to do this action..
thanks

[Satish1414 · Accepted solution]

Hi Lorenzo ,

you can use the inbuilt function "Replace" to do the above calculations 


Hope this helps .

Regards,
Satish Gunturi
Senior Consultant
Ignite IPA Pvt Ltd