Use Text to Columns for removing hidden characters between words in Group or Category names if the import isn't working.
Use the hidden character as the delimiter (copy it and paste into Other box), then recombine words using the concatenation function. 
- Rob Gandee

Excel Tips & Tricks


watch our 7 minute

intro video

watch a quick introductory video that will give you a basic overview of our business budgeting platform and its key features.