Profile

Cover photo
Yogi Anand
851 followers|1,304,267 views
AboutPostsPhotosYouTube+1's

Stream

Yogi Anand

Shared publicly  - 
 
yogi_Given A Table Of Contacts Split Entries Into 'FirstName' 'Spouse FirstName' 'LastName'

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
Honoring Pama Function May-14-2016
Pancharathna, Pama as her nephews, and nieces lovingly call her was honored by family for her contributions to the family and the community.  Inspired by the lead taken by Pama's nephew Pradeepan, the whole family got together and invited the family members...
Inspired by the lead taken by Pama's nephew Pradeepan, the whole family got together and invited the family members from all over the States, and Canada, and the friends in the area to recognize Pancharathna for all she has done. Venue was beautiful conference hall at Bharatiya Temple in Troy ...
1
Add a comment...

Yogi Anand

commented on a post on Blogger.
Shared publicly  - 
 
Hi +Gringo en Costa Rica :

if you have a phone number as 5555551212 in cell A2
and you want to change it to 1 555-555-1212
then
one way
write the following formula in cell B2:
="1 "&replace(replace(A2,4,"","-"),8,"","-")

or apply following Custom number format to cell A2
"1 "000-000-0000
this will reformat the number in cell A2 iself

I hope this helps.

Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com In this spreadsheet 10-digit phone numbers in Form Responses sheet have been entere...
1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_Assign Numeric Value To Text Attributes And Sum Up Row By Row Score From Different Sheets

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_Custom Sort Data In Columns E2:H To match The Order Of Entries In Columns A2:A

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_Pull From Sheet1 Only First Instance Of Records In Columns A to D

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_Compute Number Of Rows That Have 0 and Frog In The Same Row In Range D8:H14
Google Spreadsheet   Post  #2065 Yogi Anand, D.Eng, P.E.       ANAND Enterprises LLC -- Rochester Hills MI         www.energyefficientbuild.com .   May-20-2016 question by: Shaun Milliken : https://productforums.google.com/forum/?utm_medium=email&utm_source...
Google Spreadsheet Post #2065 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-20-2016 question by: Shaun Milliken: https://productforums.google.com/for...
1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_Compute Dates In Cell A2 And Down That Are Before Date In Cell A1 Skipping Weekends

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_For Domains In Column A Of Sheet2 Assign Highest Rating Based On 'Best' 'Good' 'Bad' From Data In Table Of Sheet1

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_From Data In 'Form responses' Sheet Compute Stats By Day_Of_Week Week_To_Date Month_To_Date Year_To_Date

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_For The List Of Descriptions Used In Cells A3 to A Sum Up Number Of Days For Which Booking Is Made

1
Add a comment...

Yogi Anand

Shared publicly  - 
 
yogi_Compute Hours By Subject From Table Of Date Subject Time_IN And Time_Out

1
Add a comment...
People
In their circles
570 people
Have them in circles
851 people
Max Larsson's profile photo
Gs Kirkman's profile photo
Collin Cantrell's profile photo
Sahil Mittal's profile photo
ALG LAW OFFICE's profile photo
Shruthi R's profile photo
Sakura Jan's profile photo
Emily Lopez's profile photo
Gregory Morad's profile photo
Links
YouTube
Yogi Anand's +1's are the things they like, agree with, or want to recommend.
Choose Browser
market.android.com

-------------------------- MY NEW APP Unlock with WiFi unlocks your device when you're connected to your home WiFi! https://market.android.c

Classroom – A brand new GAFE tool for teachers
www.googlegooru.com

Classroom is a new, free tool coming to Google Apps for Education that helps teachers easily and quickly create and organize assignments, pr