Search code examples
excel-formulaexcel-2011

Adding a space in excel text

I have a list of ID's (e.g. BSAR1, BSAR2).How can I easily add in a space after each BSAR automatically.

Is there a tool/function?

Solution

  • If needing to do this surgically without using find/replace, I would use the below formula where your list of BSAR ID's falls into column A:

    In an adjacent cell, such as B1, enter the following:

    =SUBSTITUTE(A1,"BSAR","BSAR ")

    From there, copy the contents of B1 as far as down you need it.

    Cheers.