A designer sometimes comes across the problem, where the database is too large to be imported through phpmyadmin. Phpmyadmin allows usually only maximum 50M database size. If your database is larger than that, you can use putty, cmder, or gitbash. I mean every CLI works pretty much.

I prefer to use cmder. It is a small program and it works.

ADDING .jpg at the end of each cell

= A1&".jpg"

REMOVING LAST 5 CHARACTERS ON THE RIGHT IN A CELL

=LEFT(A1;LEN(A1)-5) instaed of =LEFT(A1,LEN(A1)-5)