Skip to content
ExcelSirJi
  • Home
  • Latest BlogsExpand
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
ExcelSirJi
EXCEL FUNCTION – TEXT
Excel Formula Tips

EXCEL FUNCTION – TEXT

ByPradeep Kumar

TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.

Read More EXCEL FUNCTION – TEXTContinue

EXCEL FUNCTION – REPT
Excel Formula Tips

EXCEL FUNCTION – REPT

ByPradeep Kumar

REPT function is used to repeat the text or cell reference to multiple times

Read More EXCEL FUNCTION – REPTContinue

EXCEL FUNCTION – SUBSTITUTE
Excel Formula Tips

EXCEL FUNCTION – SUBSTITUTE

ByPradeep Kumar

SUBSTITUTE function is used to substitute the existing old text to new text.

Read More EXCEL FUNCTION – SUBSTITUTEContinue

EXCEL FUNCTION – SEARCH
Excel Formula Tips

EXCEL FUNCTION – SEARCH

ByPradeep Kumar

SEARCH function is used to find “position of character or text” in an available cell and this function is NOT case sensitive.

Read More EXCEL FUNCTION – SEARCHContinue

EXCEL FUNCTION – FIND
Excel Formula Tips

EXCEL FUNCTION – FIND

ByPradeep Kumar

FIND function is used to find the position of text, or character in an available string.

Read More EXCEL FUNCTION – FINDContinue

EXCEL FUNCTION – LOWER
Excel Formula Tips

EXCEL FUNCTION – LOWER

ByPradeep Kumar

LOWER function is used for changing the format of any text or string to LOWER case.

Read More EXCEL FUNCTION – LOWERContinue

EXCEL FUNCTION – PROPER
Excel Formula Tips

EXCEL FUNCTION – PROPER

ByPradeep Kumar
How to use “PROPER” function in Excel PROPER function is used for changing the format of any text or string to PROPER or SENTENCE Case. PROPER Function has argument only one argument i.e. text, which...

Read More EXCEL FUNCTION – PROPERContinue

EXCEL FUNCTION – UPPER
Excel Formula Tips

EXCEL FUNCTION – UPPER

ByPradeep Kumar

UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.

Read More EXCEL FUNCTION – UPPERContinue

EXCEL FUNCTION – LEN
Excel Formula Tips

EXCEL FUNCTION – LEN

ByPradeep Kumar

LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.

Read More EXCEL FUNCTION – LENContinue

EXCEL FUNCTION – RIGHT
Excel Formula Tips

EXCEL FUNCTION – RIGHT

ByPradeep Kumar

RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.

Read More EXCEL FUNCTION – RIGHTContinue

EXCEL FUNCTION – MID
Excel Formula Tips

EXCEL FUNCTION – MID

ByPradeep Kumar

MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.

Read More EXCEL FUNCTION – MIDContinue

EXCEL FUNCTION – LEFT
Excel Formula Tips

EXCEL FUNCTION – LEFT

ByPradeep Kumar

LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell

Read More EXCEL FUNCTION – LEFTContinue

EXCEL FUNCTION – CONCATENATE
Excel Formula Tips

EXCEL FUNCTION – CONCATENATE

ByPradeep Kumar

CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.

Read More EXCEL FUNCTION – CONCATENATEContinue

EXCEL FUNCTION – TODAY
Excel Formula Tips

EXCEL FUNCTION – TODAY

ByPradeep Kumar

Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.

Read More EXCEL FUNCTION – TODAYContinue

EXCEL FUNCTION – WEEKDAY
Excel Formula Tips

EXCEL FUNCTION – WEEKDAY

ByPradeep Kumar

WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7

Read More EXCEL FUNCTION – WEEKDAYContinue

EXCEL FUNCTION – NOW
Excel Formula Tips

EXCEL FUNCTION – NOW

ByPradeep Kumar

Microsoft Excel “NOW” function is used to get the current Date and Time. It is very useful function and can be used in many ways.

Read More EXCEL FUNCTION – NOWContinue

EXCEL FUNCTION – HOUR, MINUTE, SECOND
Excel Formula Tips

EXCEL FUNCTION – HOUR, MINUTE, SECOND

ByPradeep Kumar

Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.

Read More EXCEL FUNCTION – HOUR, MINUTE, SECONDContinue

EXCEL FUNCTION – DAY, MONTH, YEAR
Excel Formula Tips

EXCEL FUNCTION – DAY, MONTH, YEAR

ByPradeep Kumar

Microsoft Excel “DAY, MONTH, YEAR Functions” are date related functions helps to extract the Day, Month or Year from a Date.

Read More EXCEL FUNCTION – DAY, MONTH, YEARContinue

EXCEL FUNCTION – DATEVALUE
Excel Formula Tips

EXCEL FUNCTION – DATEVALUE

ByPradeep Kumar
How to Change TEXT into DATE Format Microsoft Excel “DATEVALUE” is the very useful where dates are available as TEXT and need to convert them to proper DATE format. DATEVALUE function helps to convert the...

Read More EXCEL FUNCTION – DATEVALUEContinue

HOW TO COMPARE TWO COLUMNS IN EXCEL
Excel Data Tips

HOW TO COMPARE TWO COLUMNS IN EXCEL

ByPradeep Kumar

Comparing Columns in Microsoft excel is much often feature that is used while managing database. We have many ways to compare the columns in excel and can be used as per the requirement. We will…

Read More HOW TO COMPARE TWO COLUMNS IN EXCELContinue

EXCEL FUNCTION – NETWORKDAYS
Excel Formula Tips

EXCEL FUNCTION – NETWORKDAYS

ByPradeep Kumar

“NETWORKDAYS” function is very helpful feature in the Microsoft excel to calculate the working days from a particular period excluding “Saturday and Sundays”. NETWORKDAYS function subtract the Start Day from the End Date provided.

Read More EXCEL FUNCTION – NETWORKDAYSContinue

Page navigation

Previous PagePrevious 1 2 3 4 5 … 7 Next PageNext
  • Sitemap
  • Privacy Policy
  • Terms of Use
Facebook Twitter Instagram YouTube

© 2022 ExcelSirJi

  • Home
  • Latest Blogs
    • Excel Formula Tips
    • Excel Data Tips
    • Excel Utilities/Templates
    • Excel VBA Codes/Macros
    • Excel Dashboarding Tips
    • Excel Power Query
  • Courses
  • Excel Functions
  • Excel Shortcuts
  • Premium Downloads
Search