Adding a space in excel text

Question

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?

Highlight the column and use replace (Ctrl-H) to replace "BSAR" with "BSAR ". — Andy G, May 19 '14 at 15:59

score 2 · Accepted Answer · answered May 19 '14 at 20:39

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.

1 Answers1