Monday, October 21, 2013

Concat two text cell in Excel

To concat two text cell in MS Excel, use CONCATENATE command.

E.g. =CONCATENATE("i";A1) -> would concat "i" to the begnning of your text at A1 cell.

Wednesday, October 16, 2013

Checks two cell text in Excel

This command, checks the A1 text with A2 text and writes TRUE or FALSE in C1. True is written in case of equality.

C1: =EXACT(A1,B1)

Monday, October 14, 2013

Removing letters from beginning / end of a cell in Excel

LEFT and RIGHT function allow you to remove the certain characters from the beginning or end of one or several. The example below removes the first 4 character from the beginning of A1 cell.

B1: =RIGHT(A1, LEN(A1)-4)

This removes 4 character from the end of the text in A1 cell.

C1: =LEFT(A1, LEN(A1)-4)