Finding and replacing multiple entries

  • Thread starter Thread starter Darryl
  • Start date Start date
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?
 
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
 
Back
Top