=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)
No Comments