Adding the same sympols within a text in various cells
Hello,
I have a list of part numbers in excel at the following format:
B154789254695
B254698536221
B256365214455
I would like to ask, how can I get this list, in the following format (by adding ".", " (space)" and "-"):
B.15 47892546-95
B.25 46985362-21
B.25 63652144-55
Is there any way to do that?
Thanks in advance!
Assuming they are all in the same format as your post
=REPLACE(REPLACE(REPLACE(A2,2,0,"."),5,0," "),14,0,"-")
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
DutchEnglisch
=LINKS(A1;1)&"."&RECHTS(LINKS(A1;3);2)&" "&DEEL(A1;4;8)&"-"&RECHTS(A1;2)=LEFT(A1,1)&"."&RIGHT(LEFT(A1,3),2)&" "&MOD(A1,4,8)&"-"&RIGHT(A1,2)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks