• Contact Me
  • About Me
  • Facebook
  • RSS Feed
  • Sitemap
  • Mail to US

Learn Excel VBA Macro

Complete Excel VBA Macro Solution

 
  • Home
  • Basics
  • Function
    • Information
    • date-and-time
    • lookup-reference
    • Statistical
    • Maths
    • Logical
    • Text Function
  • VBA-Macro
    • VBA Function
    • VBA TIPS
    • ActiveX Controls
  • Some Other Excel Tips
    • Pivot Table Help Page
    • Print Help Page
    • Data Validation In Excel
    • Excel Shortcuts
    • More Excel Tips
  • MIS Executive Interview Questions

Month: August 2017

August 31, 2017 Basic, Text One comment

combine two cell values use of concatenate function

Learn how to combine two cell value in excel with use of concatenate function. We can also use & to join to two or more cell value. If A1 Cell value is My and B1 Cell value is Book, we have type =A1 & B1 in C1 cell, it will return MyBook, we can give space here also use of =A1 & ” ” & B1 formula, then output will be My Book.     Text Function

Read more
August 31, 2017 Basic, Function, Text Leave a comment

Extract text from right side from a Cell

With Use of right function in MS Excel. We can extract some text from right side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from right side of call value               Text Function

Read more
August 25, 2017 Basic, Text Leave a comment

Find Out How Many Words Used In A Cell

With the help of Len & Substitute Function. We can found out how may words used in a Cell.       Text Function  

Read more
August 15, 2017 Function, Text Leave a comment

Extract text from left side from a Cell

With Use of left function in MS Excel. We can extract some text from left side from a cell value. for Example:- If we have computer in A1 cell. With below formula we can extract 3 character from left side of call value             Text Function

Read more

Subscribe

Get update on Latest Post by E-Mail

Recent Posts

  • MIS-Interview Series-Q8
  • MIS-Interview Series-Q7
  • MIS-Interview Series-Q6
  • MIS-Interview Series-Q5
  • MIS-Interview Series-Q4

Categories

  • Basic (5)
  • EXCEL VBA TIPS (2)
  • Function (16)
    • Date and Time (2)
    • Logical (2)
    • LOOKUP & Reference (5)
    • MATHS (1)
    • Text (6)
  • MIS (2)
  • MIS Interview Questions (6)
  • Some Other Excel Tips (8)
  • Uncategorized (8)
  • VBA/Macro (9)
    • VBA (2)

Archives

  • January 2022 (3)
  • September 2021 (2)
  • May 2021 (1)
  • October 2020 (1)
  • September 2020 (2)
  • June 2020 (3)
  • May 2020 (1)
  • April 2020 (1)
  • March 2020 (1)
  • April 2019 (1)
  • December 2018 (1)
  • November 2018 (1)
  • October 2018 (1)
  • September 2018 (1)
  • August 2018 (2)
  • July 2018 (1)
  • March 2018 (3)
  • February 2018 (4)
  • January 2018 (6)
  • December 2017 (6)
  • October 2017 (2)
  • August 2017 (4)

Please go to Appearance → Menus and create a new custom menu with custom links to all your social networks. Then click on "Manage Locations" tab and assign your created menu to the "Social Icons" location.

Powered by Dukan Theme