Add single/double quotes around text/numbers in Excel

preview_player
Показать описание
The video offers a short tutorial on how to add single/double quotes around text/numbers in Excel.
Рекомендации по теме
Комментарии
Автор

but it is not working for number data cells

EngineerBilalMaqbool
Автор

Is there a way to do it WITHOUT adding another column? I'm talking about changing 1234 to '1234'.

ruimotta
Автор

Thanks a lot Prashant. Really helpful I am looking for this trick since very long

akankshamangarolia
Автор

Woohoo! Thank you so much! I have been looking for this for ages! It worked! 🙏🙏🙏

taliabrowne
Автор

Awesome stuff brother...saved a lot of time.

dhavalpatel
Автор

Don't know why but this doesn't work . The video is blurred am I doing something wrong? I want single quotes eg 'abc'.

The answer is ='' ' ''&A2&'' ', '' putting space between! Kindly comment the formulas you used as the video resolution is not great!

gmm
Автор

Thanku u please sent your contact id
I want to learn more tips in excel

deepakrathor
Автор

Dude seriously why to upload such videos where we cannot see what formula you are using and instead you should have written the formula on the notepad

kowshik