Hi Joseph I don't see any problem with that. You only need to change the range. In most conversions, I would be extremely happy to get 80% corre...
Hi Joseph When splitting names and addresses, is very difficult to get them 100% correct due to the different formats. I have attempted to split...
Hi Leeroy I would copy column B to Googlesheets and then use DETECTLANGUAGE() to get the language code. Then copy the results back to Excel and ...
Hi Leeroy It would help if you can attach some sample data so that we can have a look at it. No idea what you meant by non-English words. (1)...
Hi Velouria My bad. Agreed, call is never necessary in VBA. The issue is the offset(,-1). It gives Run-time error '1004'. Application-define...
The original code didn't work for me. After a little modification it looks OK. Sub loadPictures() For Each cell In Selection Call addpic(cell.Va...
Hi Allyn You can have a look at the attached. It generates a bunch of random unique numbers in column B and then does a VLOOKUP to match the num...
Hi Melinda Give this a try. Hope this helps. Sunny
Hi Anne I suspect you keyed 11 zeroes instead of 10 in your formula. The formula will only add a zero to the front of numbers with 9 or less dig...
Hi CY No problem. Sunny
Hi Anne You can try =TEXT(A1,"0000000000") It works for both 9 or 10 digit numbers. Please note that this will convert the numbers to text. ...
Hi Chiew Yen Please refer attached. Hope this helps. Sunny Kow
Hi You can refer here for examples on how to get the Product SKU. =INDEX($D$2:$D$4,SUMPRODUCT(ISNUMBER(SEARCH($D$2:$D$4,C2))*ROW($1:$3))) ...
You can also try =SUBSTITUTE(D5,CHAR(160),"")+0
Hi Eric Give this a try. I am assuming only number of rows will change and the columns are fixed at 15. The macro will check for the last row us...