Posts by lperson

    "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:

    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?