Formula Left and Right

Formula Left and Right

	A	B	C
2	Ameen Akbar	Ameen	Akbar

Spreadsheet Formulas

Cell Formula B2 =LEFT(A2,FIND(" ",A2)-1) C2 =RIGHT(A2,LEN(A2)-FIND(" ",A2))

another formula
B2: =LEFT(A2,FIND(" ",A2,1)-1) and this one in C2: =RIGHT(A2,LEN(A2)-FIND(" ",A2,1)).

Quran in MicroSoft Excel

Quran in MicroSoft Excel

Unicode Quran in MicroSoft Excel file. Use filter option to fast access any ayat.

 

Download Link

DOWNLOAD

Root Letters

Root Letters

This excel file will help you to look up root word of Word of Quran. All words are given in Surah and Ayat wise, With this excel sheet you can also locate the any word in Quran in Edward William Lane Lexicon. 

With this excel sheet any reader can look any root word in lexicon easily. Use data fitler  for fast access to related Surah and Ayat.

  

Download Link of Excel  .xlsx File (Office 2007 and above)

DOWNLOAD

Download Link of Excel .xls file (Office 97 - 2003)

DOWNLOAD