I have a worksheet with mixed food and beverages, my issue is put asterisk * in column I where description has splitting packages like 6x50cl, 6x75cl, 6x1,5L,,6x1 litre,.
This is a sample as there are beverages which has only e.g 1.5 litre or 0.75 cl and so on
Am looking a formula or vba to insert In column I an asterisk" * " .
The list is very bulky of 15000 rows of data.
Can anyone assist.
Have attached before and after results
Bookmarks