Profile

Cover photo
Prasad tr
Works at ProdEx Technologies
Lives in Chennai
173 followers|392,889 views
AboutPostsCollectionsYouTubeReviews

Stream

Prasad tr

Shared publicly  - 
 
How to use excel formula to get dynamic results
Here, we will see how we can get dynamic output with a simple function. For example, assume that you have an Excel sheet having some 2000 web domain names ending with forward slash  "\"    How will you remove that forward slash  "\" from the list? Using LEF...
In =LEFT(A2,24) number 24 has to change based on cell length. By using another simple formula, LEN, you can find the number of characters in the cell. Syntax=LEN(text) = It will tell us number of characters in a cell. Now, using both LEFT and LEN, we can get dynamic results.
1
Add a comment...

Prasad tr

Shared publicly  - 
 
watch it
 
BEAUTIFUL  NATURE  SCENES !
1
Add a comment...

Prasad tr

Shared publicly  - 
Follow me on Facebook Google+
1
Add a comment...

Prasad tr

Photopool  - 
 
Hen and chick
9
3
Add a comment...

Prasad tr

Shared publicly  - 
1
Gargi Sahani's profile photoPrasad tr's profile photo
2 comments
 
Thank you +Gargi Sahani
Add a comment...

Prasad tr

Shared publicly  - 
1
Add a comment...

Prasad tr

Shared publicly  - 
 
**
Count The Number Of Cells With Text In Excel       If you need to count a text in Microsoft Excel, what we do?       We know =count ( ) formula  to count the number of cells with Contain number.       But count the cells with Contain TEXT?           = COUNT...
The following table was used by a school to keep track of the examinations taken by students. Each exam passed was graded as 1, 2 or 3. A failure was entered as Fail. The school needed to known how many students sat for each exam. The school Also needed to know how many exams were taken by ...
1
Add a comment...

Prasad tr

Shared publicly  - 
 
Onam
1
Add a comment...

Prasad tr

commented on a video on YouTube.
Shared publicly  - 
 
Nice ..Great work.

Prasad tr

SPAM. (Read Rules).  - 
 
Hen and chick
17
2
Kari martin's profile photoPrasad tr's profile photo
2 comments
 
Thank you +Kari martin  :)
Add a comment...

Prasad tr

Shared publicly  - 
1
sunitha s's profile photo
 
hai
  
Add a comment...
Prasad's Collections
Work
Skills
Microsoft Excel, CRM Admin
Employment
  • ProdEx Technologies
    present
Basic Information
Gender
Male
Good service
Public - a month ago
reviewed a month ago
Good service in my door step. Thank you ranjith.
Public - 5 months ago
reviewed 5 months ago
Too Bad service. Water games they give dress compulser we need pay rent, for that big Q. Locker again we have pay. We won't get locker immediate. No sufficient staff to control who took picture in swimming pool. Each water game we need to wait half hour they don't have suffent air balloon to play... Totally east for 425/- rupees + dress 30/- + locker 40/- if u want towel extra (Dress& towel for rent) NOT WORTH FOR MONEY
Public - a year ago
reviewed a year ago
ABOUVE CONTACT NO. IS WRONG....
Public - 6 years ago
reviewed 6 years ago
6 reviews
Map
Map
Map
Product finishing good and good service.
Public - 5 years ago
reviewed 5 years ago