Question: I have a column in Excel, it has text like: arrow-keys avocado B b- badger bank baseball baseball-bat baseball-glove Android-send-text-message Desired output: a r r o w - k e y s a v o c a d o B b - b a d g e r b a g e l b a n k b a s e b a l l - b a s e b a s e b a l l - b a t b a s e…

[image] hello: VBA code that works on OSX and if you wanted a declarative version (avoiding loops), you could write: Function SpacedChars(Str As String) As String SpacedChars = Join(Split(StrConv(Str, vbUnicode), vbNullChar), " ") End Function [Screenshot 2021-04-29 at 13.04.51]

Split Characters in an Excel File

order:views order:latest order:likes

status:open status:closed status:archived status:noreplies status:single_user

category:foo tag:foo user:foo group:foo badge:foo

in:likes in:posted in:watching in:tracking in:private in:bookmarks in:first in:pinned in:unpinned

posts_count:num before:days_or_date after:days_or_date

Split Characters in an Excel File

Options