Hi all ;
i want to insert a macro into my excel sheet to replace each cell in a colum A :
from format :
ABC/R1/S2-7 -11
to This one ??
ABC R1.S2.LT5 .11
p.s. 7 - 2 = LT5
cAN ANY BODY HELP !!!
Printable View
Hi all ;
i want to insert a macro into my excel sheet to replace each cell in a colum A :
from format :
ABC/R1/S2-7 -11
to This one ??
ABC R1.S2.LT5 .11
p.s. 7 - 2 = LT5
cAN ANY BODY HELP !!!
I think you mean a *formula* - not "macro" which is code separate from a worksheet.
This does what you asked from the data supplied, but you may need to adapt it according to other cell contents :-
=CONCATENATE(LEFT(A1,3)," ",MID(A1,5,2),".",MID(A1,8,2),".LT",VALUE(MID(A1,11,2)-2)," .",RIGHT(A1,2))
What about the highlighted 1-digit ..
ABC/R1/S2-7-8
your formula will work only if there was only more than 1 digit there but if there was only 1 digit the the formula then will be worng !!!!
17 must be LT15 and 7 must be LT5
Hi Guys ,,, I still Didnt get a reply from you ..
Any Help !??
I want to return the String between the two "-" :
ABC/X1/Y1-10-1
The result must be 10 or what ever between the two "-" !!
Thnx