How do I add a specific format to a series of codes

A

acanning

Joined
Jan 6, 2011
Messages
1
Reaction score
0
How do I add a specific format to a series of codes in excel? I have thousands and thousands of codes to chage and would be tedious to change them all manually

For example:

I have the following in Column C:
B08 D06
B08 D07
B08 D07
B08 E01
B08 E02
B08 E02
B08 E03
B08 E04
B08 E05
B08 E05
B08 E06
B08 E07
B08 E07
B08 F01

I want the following format with dashes and slashes in column D:
B-/08/D--/06
B-/08/D--/07
B-/08/D--/07
B-/08/E--/01
B-/08/E--/02
B-/08/E--/02
B-/08/E--/03
B-/08/E--/04
B-/08/E--/05
B-/08/E--/05
B-/08/E--/06
B-/08/E--/07
B-/08/E--/07
B-/08/F--/01

Please help???
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert range of years to series 10
Sum value between two dates and copy to new cell 6
Lookup part of a cell's contents and return value of entire cell 2
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
How to Shorten a repetitive formula to include more references. 7
what formula can i use to find a specific value? 1
sum of info in a range based on dates 4
How to adapt a formula? 2

Top