Article on the subject of "substitute function"
-
8 little-known Excel functions that can save you a lot of work
even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
-
Save time with these text formatting functions in Microsoft Excel
microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many
-
SUBSTITUTE function - The function replaces text strings in Excel
in the course of working you have excel data file need to change a series of data over the years. with a simple operation, you can change all that data. the following article details the substitute function - the function replaces the text string in excel.
-
How to use the function to delete spaces in Excel
deleting white space with functions in excel makes it easier for users to handle content, instead of traditional editing.
-
Difference between REPLACE and SUBSTITUTE in Microsoft Excel
replace and substitute are two common functions with quite similar names in excel. however, the way to use replace & substitute is different.
-
Instructions on how to count words in cells in Excel
in many cases you want to count the number of characters in a text string (text string) to calculate or combine with other functions, or to do something. you can then use the trim function, combining the len function, the substitute function. using the trim function to remove spaces, use the
-
Save time with these text formatting functions in Microsoft Excel
microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many
-
8 little-known Excel functions that can save you a lot of work
even seasoned excel users often find themselves stuck performing tasks manually that could be automated with a few clever functions.
-
How to create space after comma in Excel
to create a space after a comma in excel, you can use a function or immediately use an available tool to do it, with a quick and very simple method.
-
How to delete dots in a series of numbers on Excel
to quickly remove the dot in the numeric sequence in excel, we can use the search or use function in excel.
-
Function in programming C
a function is a group of commands that go together to perform a task. each c program has at least one function, main (), and all most normal programs define additional functions.
-
DAY function in SQL Server
the day function in sql server returns an integer that is the day of the month (from 1 to 31) from the time passed.
-
MIN function in SQL Server
the article will explore and show you how to use the min function in sql server to find the smallest value in a set.
-
MAX function in SQL Server
the article will explore and show you how to use the max function in sql server to find the maximum value in a set.
-
SUM function in SQL Server
the sql server sum function returns the total value of a column, a data set, or an expression.
-
The ord () function in Python
the built-in ord () function in python returns an integer representing the unicode code of the specified character.
-
RIGHT function in SQL Server
the article will explore and guide you how to use the right function in sql server to extract some characters from the right side of a given string.
-
Int () function in Python
the int () function in python returns an integer object from any number or string.
-
AVG function in SQL Server
the avg function in sql server returns the average value of an expression or average value according to the specified column of the selected row.
-
6 Conditional Functions That Make Excel Spreadsheets Smarter
if your formulas get complex, conditional functions are a smarter choice, hidden in plain sight.
-
Hex () function in Python
the hex () function is one of python's built-in functions, used to convert an integer into the corresponding hexadecimal form.
-
ABS function in SQL Server
this article will show you in detail how to use the abs () handling function in sql server with specific syntax and examples to better visualize and capture functions.
Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
System
