Topic 2 - Spreadsheets

Study Unit 4 / 5: Exam – TEXT

=TEXT FUNCTIONS

JUST AS YOU CAN JOIN TOGETHER PIECES OF TEXT, YOU CAN ALSO SPLIT UP A STRING OF TEXT.

You could join the values from these two cells to create a full name with this formula:

=A1 & A2

To add a space (between quotation marks) into your formula, like so:

=A1 & ” ” & A2

IN ADDITION, THE LEFT( ), MID( ), AND RIGHT( ) FUNCTIONS LET YOU EXTRACT A PORTION FROM A LARGER TEXT STRING.

  • THE TEXT( ) FUNCTION USES THE & CHARACTER
  • AND YOU NEED TO ENCLOSE THE TEXT USING THE “ CHARACTER

IF YOU TRY TO PERFORM A CALCULATION BY REFERRING TO ONE OR MORE CELLS   CONTAINING TEXT, EXCEL DISPLAYS A #VALUE ERROR MESSAGE.

=TEST(A1&”123”&C1,0)

 

Study Unit 4 / 5: Exam – Logical Test (Prev Lesson)
(Next Lesson) Study Unit 4 / 5: Exam – COUNTIF
Back to Topic 2 – Spreadsheets

No Comments

Comments are closed.