Text mining in MS-Excel

-


  1. UPPER: Converts text to uppercase. Example: =UPPER("text") returns "TEXT".
  2. LOWER: Converts text to lowercase. Example: =LOWER("TEXT") returns "text".
  3. PROPER: Capitalizes the first letter of each word. Example: =PROPER("hello world") returns "Hello World".
  4. LEFT: Extracts a specified number of characters from the start of a text string. Example: =LEFT("Excel", 2) returns "Ex".
  5. RIGHT: Extracts a specified number of characters from the end of a text string. Example: =RIGHT("Excel", 2) returns "el".
  6. MID: Extracts a substring starting at a specified position. Example: =MID("Excel", 2, 3) returns "xce".
  7. LEN: Returns the number of characters in a text string, including spaces. Example: =LEN("Excel") returns 5.
  8. SEARCH: Finds the position of a text string within another (case-insensitive). Example: =SEARCH("c", "Excel") returns 3.
  9. FIND: Finds the position of a text string within another (case-sensitive). Example: =FIND("c", "Excel") returns 3.
  10. SUBSTITUTE: Replaces occurrences of old text with new text. Example: =SUBSTITUTE("Excel", "c", "x") returns "Exxel".
  11. REPLACE: Replaces part of a text string with another. Example: =REPLACE("Excel", 2, 3, "mpl") returns "Empl".
  12. CONCAT: Joins multiple text strings into one. Example: =CONCAT(A1, B1) combines the text in A1 and B1.
  13. TEXTJOIN: Joins text strings with a specified delimiter. Example: =TEXTJOIN(", ", TRUE, A1, B1, A2) joins with commas.
  14. TRIM: Removes extra spaces from text. Example: =TRIM(" Excel ") returns "Excel".
  15. CLEAN: Removes non-printable characters from text. Example: =CLEAN("Excel ") returns "Excel".
  16. EXACT: Checks if two text strings are exactly the same (case-sensitive). Example: =EXACT("Excel", "excel") returns FALSE.


Comments

Post a Comment

Popular posts from this blog

UGC guidelines for undergraduate internship

-
The University Grants Commission (UGC) has issued guidelines to promote internships for undergraduate students under the National Education Policy (NEP) 2020, aiming to enhance employability, skill development, and experiential learning. Here are the key points of the UGC Guidelines for Undergraduate Internship: 1. Duration and Credit Allocation Internships are mandatory and should be a part of the undergraduate curriculum. Minimum duration: 8–10 weeks (approx. 2–3 months). Internships carry 2 to 4 credits, depending on the duration and effort. 2. Types of Internships Research internships with faculty or institutions. Industry internships in private or public sectors. Social or community engagement internships (NGOs, Panchayats, local bodies). Entrepreneurial internships or field-based projects. 3. Implementation Framework Institutions must have an Internship Cell. A mentor or faculty guide must supervise the internship. MOUs with industries or organizations are encouraged. 4. Assessme...
Read more

6-months course on Foundation of School psychology

-
School psychology is a specialized field that combines psychology, education, and child development to support the academic, social, and emotional well-being of students. School psychologists work with students, teachers, parents, and other school professionals to create a supportive and inclusive learning environment. This course provides an overview of the principles, theories, and practices of school psychology. Students will learn about the historical and philosophical foundations of school psychology, as well as the key concepts and methods used in the field. Topics will include: Throughout the course, students will engage in discussions, readings, and activities designed to promote critical thinking, problem-solving, and professional growth. By the end of the course, students will have a comprehensive understanding of the field of school psychology and be prepared to apply this knowledge in real-world settings. Registration : click here Course Outcomes: By the end of this course,...
Read more

Therapeutic postulates of Rabindrik Psychotherapy

-
1. Consciousness is free floating ‌2. It is unbound. ‌3. Do not label rather understand other's consciousness. ‌4. Consciousness is composed of three layers Murta, Raga and Saraswat. ‌5. Experience of Consciousness is like a journey from incomplete to complete across three layers. ‌6. Man is pursuer of newness. ‌7.Man is pursuer of completeness. ‌8. Searching newness makes man incomplete that acts as the driver to find out completeness. ‌9. Incomplete to complete is a cyclic process. ‌10. Image characteristics change across layers of consciousness. ‌11. Man has power to customise environment for change in consciousness layers. ‌12. Incoming images  are changed when it came out from saraswat layer. ‌13. Murta image has structure but no affect or emotion. ‌14. Raga layer based image is affected by emotion. ‌15. Saraswat image indicates harmony of object and environment. ‌16. Incom...
Read more