The CONCATENATE function

The Concatenate function concatenates texts in different cells and allows you to write them in one single cell. Texts can be edited in a very flexible way with the Concatenate formula.

In this manner, you can freely change any field you want in the formula and get the desired result.

The arguments of the formula consist of successive textual expressions.

=Concatenate(text1, text2,…)

You can select the texts to be concatenated from the related cells one-by-one.

In the example bellow, the address is created by concatenating the Strict, Street and Number. When the A2, B2, and C2 cells are concatenated directly, it created the MerkezAyazma37 result.

To see a more familiar result like Merkez Strict Ayazma Street Number:37 (this is the Turkish way of writing an address), what can we do?

You can write textual expressions like “Street”, “Strict” into the formula with the long method.


*When you need to write a text with the keyboard into the formula, you need to write it into a double-quote (“ ”). Using texts in ” ” in Excel is pretty strict.

A more efficient method for it to be reusable, editable and controlled centrally is to write strict, street, number information into a cell and use that cell as a reference.

Click here to take a look the the details of the Concatenate formula.

In addition, it to possible to concatenate without using a function. You can use the & symbol as a concatenation operator. It works similar to the concatenate function and allows you to concatenate the texts directly.

We have learned how to concatenate texts above. In addition to this, we might want to separate concatenated texts as well.

You can separate texts written in one cell into separate cells with the Convert Text to Columns function. So, it works the opposite way of the Concatenate function. Click here to read our article about Convert Text to Columns.

Text Functions

Power Apps Writing Formulas

PowerApps has its own software language and its special functions. Alongside these functions, it also contains a lot of functions that exist in Excel. These functions are offered in a general frame, they are not separated into categories as function groups like text, date, and statistic. In this article, we will analyze text functions.

It is very practical to code with PowerApps, with the formula language you are used to from Excel.

You can write all formulas on objects. After you choose the related object, you can write on Formula Bar.

*While writing a formula, you can write with commas (,) or semicolons (;) (depending on the browser language), you don’t need to use the equal sign.

Text Functions

There are basic text functions like Concatenate, Left, Right, Mid, Len, Upper, Lower in the Power Apps functions. You can edit or create text expressions with these functions.

Let’s write the formulas below for a textbox in which Text Functions is written. The name of this textbox is txt_sampletext.

The Concatenate function concatenates a mix of individual strings and a single-column table of strings. When you use this function with individual strings, it’s equivalent to using the & operator.

Concatenate( String1 [, String2, …] )

Concatenate(txt_sampletext.Text;  txt_sampletext.Text;  txt_sampletext.Text)

 

Left function returns the beginning characters of a string.

Left( String, NumberOfCharacters )

Left(txt_sampletext.Text;1)

 

 

Mid function returns the middle characters of a string.

Mid( String, StartingPosition [, NumberOfCharacters ] )

Mid(txt_sampletext.Text;3;1)

 

 

Right returns the ending characters of a string.

Right( String, NumberOfCharacters )

Right(txt_sampletext.Text;1)

 

 

Len function returns the length of a string of text.

Len( String )

Len(txt_sampletext.Text)

 

 

Lower function converts any uppercase letters to lowercase.

Lower(txt_sampletext.Text)

 

 

Upper function converts any lowercase letters to uppercase.

Upper(txt_sampletext.Text)

 

 

Proper function converts the first letter in each word to uppercase if it’s lowercase and converts any other uppercase letters to lowercase.

Proper(txt_sampletext.Text)

 

 

The Trim function removes all spaces from a string of text except for single spaces between words.

Trim(txt_sampletext.Text)

 

 

The TrimEnds function removes all spaces from the start and end of a string of text but leaves spaces between words intact.

TrimEnds(txt_sampletext.Text)

 

You can access the list of all the other functions here.