macro find and replace in a specific column specific words to an abreviation

I have a data file where sometimes I need to adjust the word Litres , litre, Litre, litres,LITRES, LITRE a specific column ,

Looking a macro to convert to L.

the column has mixed data

6*3*1,3 litre
36*6* 2.5 LITRE
36*6* 3.5 LITRE



6*2*75CL




6*7*75CL
6*6*75CL

6*2*75CL

6*4*75CL
6*3*75CL
6*11*70CL
6*7*70CL
6*7*70CL
6*6*70CL
6*14*70CL
6*2*75CL
4*38*20CL
4*38*20CL
6*35*1L

12*6*37.5CL
6*3*75CL

9*6*1.5L

6*4*75CL




6*20*1L




24*3*50CL

6*18*75CL
6*10*75CL
6*18*1.5L
6*18*70CL
6*4*70CL
6*29*2L



6*8*75CL
12*3*75CL
6*7*100CL
6*5*1L
6*4*70CL
6*1*70CL
6*4*50CL
6*3*50CL
6*3*50CL
6*4*70CL
6*4*70CL
6*30*70CL
6*20*37.5CL
6*2*70CL
6*20*70CL
6*20*1.5L
6*20*1.5L

Is it?

Please Login or Register  to view this content.

Tried but nothing happens

OOps, I thought it would be col.L,
Change

Please Login or Register  to view this content.

to A or any col(s) that you are applying to.

JEAN1972,

You are welcome and thanks for the rep.