Aug 13, 2019
Is it possible to add pronunciation of English word to google sheet ?
Details
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Aug 13, 2019
added this to cell h1
={"LINK";Arrayformula(If(B2:B="",,hyperlink("www.google.com/search?q="&B2:B&" pronunciation",B2:B)))}
it by no means perfect
on most words - the pronunciation is first search result - however - other not
Original Poster Ahmed Khalaf marked this as an answer
Hello All,
Mchall C good work around/solution. Just to add to that here is a link to Google translate
https://translate.google.com/#view=home&op=translate&sl=auto&tl=es&text=word
you can use this in your formula. auto is the language detection I would leave this on auto probably, es is the language code to be translated to es=Spanish, don't know if this would matter since were not really trying to translate but just pronunciation and word would be the text within the sheet to be pronounced.
Hope this helps,
Stephen
Original Poster Ahmed Khalaf marked this as an answer
All Replies (28)
Aug 13, 2019
Aug 13, 2019
its in J1 on your sheet
={"LINK 2";Arrayformula(If(B2:B="",,
hyperlink("https://translate.google.com/#view=home&op=
translate&sl=auto&tl=es&text="&B2:B,B2:B)))}
hyperlink("https://translate.google.com/#view=home&op=
translate&sl=auto&tl=es&text="&B2:B,B2:B)))}
Aug 13, 2019
this works and is in cell j1 of your sheet
={"LINK 2";Arrayformula(If(B2:B="",,
hyperlink("https://translate.google.com/#view=home&op=translate&sl=auto&tl=ar&text="&B2:B,B2:B)))}
Aug 13, 2019
Aug 13, 2019
Thanks a lot
Last edited Aug 13, 2019
Aug 13, 2019
support.google.com/docs/thread/11928709
Aug 13, 2019
I made best answer to Stephen
And regarding to my new post I just to get the whole meaning from the English word to Arabic meaning
like the column D
I did that one by one so is there any way to do it automaticaly
Thanks a lot Mchall C
Aug 13, 2019
have added a sheet to your spreadsheet
this is the best i can do - the synonyms for words cannot be got automatically - not that i know
had to copy from google translate - where they were listed
Aug 13, 2019
Dear Mchall C
I know that you did your best with me
and I'm thankful good luck to you
Feb 17, 2020