Changing text data - remove/add/edit

[Mattrixdesign]

Looking to do some sort of find/replace/edit automatically for about 400 lines of data, I am not sure what this would be called so not even able to find the right function/help on XL.

E.G.

This is the part number I have "aaaabbccccdddd"

I want the result to remove "aaaa", add a prefix 1234, and add dashes, so the result looks like this "1234-bb-ccc-dddd"?

Any ideas?

Thanks

 

[jbeaucaire]

Assuming the strings are all the same length and your question is accurately presented, assuming the first string is in A1, put this formula in row1 in an empty cell, then copy down the 400 rows:

="1234-"&MID(A1,5,2)&"-"&MID(A1,7,4)&"-"&MID(A1,11,4)

 

[Mattrixdesign]

One tweak and its perfect, many thanks!