Finding and replacing multiple entries

D

Darryl

Does anybody know a way to replace multiple varying
entries at the same time? I am trying to insert dashes in
numeric sequences. The numbers are all the same length.
Some have letters in them. And all the dashes will be
going in the same place.
Example:
Original entry: 0002056MPR
I want: 000-2056-MPR

I have hundreds of these to do. Can anyone help me?
 
T

Tim Otero

One way:

Provided the original entry is in A1, the formula would be:

=LEFT(A1,3)&"-"&MID(A1,4,4)&"-"&RIGHT(A1,3)

You can copy this down a column of cells to change entries in column A

tim
 
Top