Excel Formula for Whatsapp Marketing

how to remove 91 from mobile number in excel

Method 1: Find and Replace (Fastest) 
  1. Select the range of phone numbers.
  2. Press Ctrl + H to open the Find and Replace dialog.
  3. In "Find what," type +91 or just 91 (depending on your data format).
  4. Leave "Replace with" empty.
  5. Click Replace All.
    Note: If there are spaces, try replacing +91 (with a space) or using * as a wildcard (e.g., +91* in Find what).     
Method 2: RIGHT Formula (For 10-digit numbers) 
If your numbers are in column A, enter this formula in column B:
=RIGHT(A1, 10) 
  • Drag the formula down to apply to all cells.
  • Copy the new cells and Paste as Values to remove the formula. 

Remove +91 

Remove Space between

Use Find and Replace 

Comments

Post a Comment

Popular posts from this blog

Fundamentals of Management Theory & Practice

Image
  📘 Fundamentals of Management Theory & Practice 1. Fundamentals of Management Theory and Practice Key Points: Definition of management (planning, organizing, leading, controlling). Classical (Taylor, Fayol), Behavioral (Mayo, Maslow), and Modern approaches. Principles of effective management. Practical Guide: 📝 Activity: Divide students into groups, assign a mini-project (e.g., planning a college fest). Let each group apply management functions step by step. 2. Relation between Vision, Mission, Values, and Objectives Key Points: Vision = Future aspiration ("Where we want to be"). Mission = Purpose ("Why we exist"). Values = Guiding principles ("How we behave"). Objectives = Measurable targets ("What we want to achieve"). Practical Guide: 🏢 Case Study: Pick a well-known company (e.g., Google, Tata). Ask students to identify its vision, mission, values, and objectives. ✍️ ...
Read more

Evolution of Marketing

Image
Evolution of Marketing — simple meaning (one-liner) Evolution of Marketing from Production to Sustainability & Customer Orientation --------------------------------------------------- Evolution of Marketing (simple meaning) Evolution means gradual development or change of something over time . Example in daily life: A caterpillar becomes a butterfly → gradual change. Mobile phones evolved from basic calls → smartphones with cameras, apps, and internet. In short: Evolution = slow progress or transformation from one stage to another. Marketing has changed step by step over time — it started with just making products cheaply (Production Era), then moved to improving product quality (Product Era), then to pushing sales (Selling Era), later to understanding customer needs (Marketing Era), and today it focuses on building long-term customer relationships and sustainable practices that also care for society and the environment. --- Step-by-step Explanation (easy t...
Read more

🚀 ChatGPT Pro Version (Go Plan) is FREE for 12 Months! 🎉

Image
 🚀 ChatGPT Pro Version (Go Plan) is FREE for 12 Months! 🎉 All teachers, students, and business professionals can now access GPT-5 with faster image creation, longer memory, and advanced AI tools — completely free for 1 year! 💡 Don’t miss this limited-time offer — it’s a golden opportunity to learn, create, and explore AI tools for your projects and career. 👉 Steps to avail the offer: 1️⃣ Open your ChatGPT app or visit https://chat.openai.com 2️⃣ Log in with your account (or create one). 3️⃣ Tap on “Upgrade to Go” on the homepage. 4️⃣ Confirm the offer — it will show ₹0/month for 12 months. 5️⃣ Start using GPT-5 and premium features instantly! 📲 Please share this message with all students and encourage them to use this amazing AI learning opportunity.
Read more