Main EXCEL commands when migrating your site

admin Wed, 10/05/2011 - 08:22
Other

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)

Add new comment

The content of this field is kept private and will not be shown publicly.
About text formats

Plain text

  • No HTML tags allowed.
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.