CODEWITHSUNDEEP
excel-formulaexcel-2011
user3234810
user3234810

Reputation: 482

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?

Upvotes: 0

Views: 48

Answers (1)

Derrik
Derrik

Reputation: 1103

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.

Upvotes: 2

Related Questions