Last answered:

18 Mar 2023

Posted on:

15 Nov 2022

1

working with text on excel

I keep getting an error message when i put the '' '' sign in the formula as shown below. Please what can i do r what are my doing wrong
image.png

2 answers ( 0 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

16 Nov 2022

0

Hi Daryl-Palma Asongu Nguatem,

Your answer looks perfectly OK.  The only way I can get an error, similar to yours, is if I have type TWO single ' (apostrophes) instead of using the " (double quote) when required.  As you can see, it is hard to tell the difference.
'' ''  - this is four single ' apostrophes with a space between each two.
" "  - this is two double quotes " with a space between.
Hope this fixes your error.

Kind regards,
Kev T.

Posted on:

18 Mar 2023

0

Why didn't he use the &", "& and space character right after the comma? putting & sign for different delimiters create confusions.

Submit an answer