Hot answers tagged


Edit In your Google thread you mention: Would really like to be able to convert this in one formula/step. ... I would love if it if could handle the whole column down. In this case, you can use the following formula =ArrayFormula(IFERROR( (REGEXREPLACE(REGEXEXTRACT(A2:A,"(^\d+\.\d+\.\d+)"),"\.","\/") &" " &REGEXREPLACE(...

Only top voted, non community-wiki answers of a minimum length are eligible