"Text to Columns" in the Data menu seems to work for the data I have. Though it is a multistep process, it is much quicker than doing it manually.
I found the answer on another bulletin board that I posed the question to.
Thanks again for your help.:flower:
Thanks. I'm not that strong in Excel to understand the functions, but appreciate your response.
I have a bunch of data that looks like this:
XXX-5RM
XXX-5ARM
XXX-5CARM
XXX-55RM
XXX-55ARM
XXX-55CARM
XXX-555RM
XXX-555ARM
XXX-555CARM
I have figured out how to put a space after the prefix (XXX) by replacing the "-" with a " ". How can I add a space before the suffix (RM, ARM, CARM)? Or is there a way of breaking out the suffix into a separate column?
