PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-ADDRESS

INTRODUCTION

ADDRESS function comes under the LOOKUP AND REFERENCE category in Excel.

ADDRESS FUNCTION returns the address of any cell which is specified by the ROW number and COLUMN number.

It gives us the option of simple calculation of Row number and Column number as it is cumbersome to handle the column names after Z.

This function also gives additional option of setting which type of ADDRESS we want. A1 type of R1C1 type. A1 type is the standard system of naming where row is shown using a number and column is marked using an Alphabet.

Whereas in R1C1 method , both row and column are shown using numbers.


PURPOSE OF ADDRESS FUNCTION IN EXCEL

TRIM FUNCTION removes the extra spaces in the given text and keeps only one standard space.

 

PREREQUISITES TO LEARN ADDRESS

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: ADDRESS FUNCTION

The Syntax for the function is

=ADDRESS(TEXT STRING)

TEXT STRING   GIVEN TEXT

 

EXAMPLE:TRIM FUNCTION IN EXCEL

DATA SAMPLE

Let us take the same line from the introduction and try our latest learnt function on that.

HELLO    THERE! HOW  ARE YOU     DOING??

 

EXCEL FUNCTION TRIM
EXCEL:TRIM FUNCTION ANIMATED EXAMPLE

STEPS TO USE TRIM FUNCTION

The text having random spaces has been taken for the example.

We can see that there are some irregular spacing in the line. So we will use the function TRIM to remove those spaces.

The formula used is

=TRIM(D9)

The text is stored in D9 which needs to be corrected. The output is shown in E9.



OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW