Column Replace

[Lina229]

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 !!!

[BrianB]

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))

[Lina229]

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

[Lina229]

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