ayi This seemed to work, but is a bit involved. Enter data into a cell. Select the Text to Columns feature. Make sure Delimited is selected and choose Next. Uncheck the check next to Space (or the delimiter you want to disable) Click Finish.
