Тёмный

Convert Text to Proper Case in MS Excel - FreeTutorialExcel.com 

Jed Jones
Подписаться 1,3 тыс.
Просмотров 114 тыс.
50% 1

www.freetutorialexcel.com
When working with worksheets whose text will be viewed by others in a report format or other form of output that others will see (e.g., a mailing list file to be printed to shipping labels), you want to make sure the text is properly formatted. Here is how to convert any text format in Microsoft Excel into proper case (first letter is capital letter, remainder are lower case).
www.freetutorialexcel.com

Наука

Опубликовано:

 

12 мар 2010

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 34   
@RobinJayneArtTickles
@RobinJayneArtTickles 10 лет назад
OMG!!! You rock! I have been reading all morning about how to do this and no one explained it as simply and easily as you. Thank you so much.
@sarahrasmussen612
@sarahrasmussen612 2 года назад
I was losing my mind trying to follow my instructor's directions. This was so much easier. Thank you!
@baldcat1810
@baldcat1810 2 года назад
This is sooo simply explained ans easily followed. I also learnt the fastest way to fill rows with the double-click in the lower right corner of the cell. Thank you so much
@sylviabrown9819
@sylviabrown9819 6 лет назад
Very Very Helpful....forgot how to do this step and it easy with your instructions. Thanks so much!
@iyangmaurice891
@iyangmaurice891 2 года назад
very smart, easy to comprehend. Thank u sir.
@gregr7045
@gregr7045 Месяц назад
I see a lot of comments are 2 years, 6 years, 9 years ago so IDK if you'll see this comment but very good presentation except for one thing that I didn't see and took me going back several times and that was before you are able to get the "paste special" dialog box to show, you cannot just make a selection for the 3 columns, you have to make selection, select COPY first and then the correct dialog shows. I kept trying to select the columns on my email list and then R-click to get Paste Special but it didn't display any Paste options. I realize too that most everyone is using a newer version of Excel but until I can get my other computer fixed, I'm stuck with 2010! Thank you for explaining where I didn't need to use CC to understand the accent!
@jmahima999
@jmahima999 23 дня назад
Thanks a lot mate. I was also not getting paste special option . Thanks for helping!
@shireenazam
@shireenazam 8 лет назад
saved so much time, thanks
@arkady714
@arkady714 4 месяца назад
Excellent stuff. Thank you for the thoughtful and useful video.
@kasherblundell1950
@kasherblundell1950 6 лет назад
Super helpful, thank you.
@rowenad.
@rowenad. Год назад
Love this video. Super helpful
@tuannuramaninat.m.nawawi5068
@tuannuramaninat.m.nawawi5068 2 года назад
you really helped me. thanks!
@malaytred779
@malaytred779 5 лет назад
thank...very helpful
@madhumithasriram6822
@madhumithasriram6822 6 месяцев назад
Thank you so much
@rohinitanayabaladevadas5799
Thank you
@josephlocklear9839
@josephlocklear9839 2 года назад
THANK YOU!!!!!!!
@Darioq57
@Darioq57 Год назад
Is there way to make it where as you enter the information into the cell, to have it change to proper case?
@jasonatmercedes
@jasonatmercedes 11 лет назад
Thank you in advance. When I attempt to use the proper function, the function remains and does not convert over the intended upper and lower case result. I'm using an exported sheet. Thanks!
@me_vinayvinayak
@me_vinayvinayak 4 года назад
Very good
@bulldogkarma
@bulldogkarma Год назад
Much appreciated but why do you leave things out. When you say you "Drag to the other columns" @ 1.07. How are you doing dragging that?
@neenieweeny
@neenieweeny 11 лет назад
I keep going wrong when it comes to the 'insert copied cells' part. My formula works, I copied values, I delete the columns I dont need anymore, but the option 'insert copied cells' doesnt come up? Also, when I delete the columns I dont want the new, proper cased columns on the far right disappear? Can you help?
@ImranKhanKhalida
@ImranKhanKhalida 10 лет назад
Great
@shivagunti
@shivagunti 7 лет назад
Hi Jed, I'm unable to save values after converting the text into proper format in MS 2013, the save option (save special) is not appearing.
@ashrafash2008
@ashrafash2008 5 лет назад
i got same problem
@LetsGoPredators
@LetsGoPredators 9 лет назад
Is there a way to make it convert into the same cell?
@josephlocklear9839
@josephlocklear9839 2 года назад
7 Years later (2022) and that's still a No.......
@kshitiz274
@kshitiz274 8 лет назад
JPT
@akhtarzamanhilal6676
@akhtarzamanhilal6676 Год назад
Please, say things a bit slowly and clearly so that it wont need to play one videos many times,thanks.
@bulldogkarma
@bulldogkarma Год назад
You can click the gear icon and select "Playback" slow.
@beckybrown6009
@beckybrown6009 7 лет назад
wow, way too fast and very little detail on what you're clicking when. If I was an expert, I wouldn't have come here.
@Ayesha_sk
@Ayesha_sk 4 года назад
Thank you
@HarryGill-wx4ux
@HarryGill-wx4ux Месяц назад
Great
@santhakumar4524
@santhakumar4524 3 года назад
Thank you
Далее
How To Convert Your Text Into Proper Case In Excel
2:02
Separate Text and Numbers in Excel (4 Easy Ways)
16:13
Просмотров 255 тыс.
Excel Shortcuts You SHOULD Know!
8:48
Просмотров 2,1 млн
ЗАКОПАЛ НОВЫЙ ТЕЛЕФОН!!!🎁😱
0:28
Colorful Vulcan w rtx 4070ti Super
13:30
Просмотров 38 тыс.