I need to change a certain stock number (AJ1101100102) so it looks like this (AJ11-0110-0102).
Is there an easy way to add the two - - between the numbers.
I use excel 2010
I need to change a certain stock number (AJ1101100102) so it looks like this (AJ11-0110-0102).
Is there an easy way to add the two - - between the numbers.
I use excel 2010
Maybe
=LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&RIGHT(A1,4)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you very much Fotis1991 it work.
assume that in "A1" = (AJ1101100102) THEN put the following formula in
"B1" =LEFT(A1,9)
"C1" = LEFT(A1,5)&"-"&RIGHT(B1,4)&"-"&RIGHT(A1,5)
THEN YOU WILL GET YOUR SOLUTION IN "C1"
HOPE IT IS WORKING FOR YOU
IF IS THERE ANY PROBLEM THEN TELL ME
Regards
CA Mahaveer Somani
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks