Agnes1730Copper ContributorApr 24, 2024Change . to - Hi! Anybody that can help with a function to change from "14.04.2024" to "2024-04-14" on a new row? I dont want to do it with normal replace function - I want to have it in a table that will do i...Show More
MAngostoIron ContributorApr 24, 2024Agnes1730 Would this serve? =TEXTJOIN("-",,RIGHT(I12,4),MID(I12,4,2),LEFT(I12,2)) Adjust cell I12 where your base original date is.
