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.