I have a string like, let's say, "aabbccddeeffgghh" in one cell and I want to convert it in something like "aa" "bb" "cc" "dd" "ee" "ff" "gg" "hh", with each group of 2 characters in a separate cell. I think I know how to put each group in separate cells (using Data/Text to columns), but I don't know how to convert from "aabbccddeeffgghh" to "aa bb cc dd ee ff gg hh" (how to add the space after each 2 chars). How can I do it, using a macro (so automatically, not manual ).
Thanks in advance!