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

#53

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.