Putting a " - " to different control number. Please help.

[bluntmagic]

I want to know and how to put a - on all of my control numbers.

This is the scenario. I have lots of control numbers on my spreadsheet which looks like this ACFBS0201011315104, ACHSK0201011315105 and so on. All of the control numbers is starting with AC.

Is it possible to put a - after the letter AC? Which will look like this AC-FBS0201011315104.

Please help me. Thank you very much.

[Tony Valko]

One way...

Assume your data is in the range A2:A10.

Enter this formula in B2 and copy down as needed:

=REPLACE(A2,1,2,"AC-")

Inspect the results and make sure it is what you wanted.

Select the formulas in B2:B10.
Right click>Copy
Right click>Paste Special>Values

You can delete the original data in column A if so desired (or, delete the entire column A).