How to use the TEXT Function in Excel

[@APFreakwiz]

I gave a thumbs up even though it wasn't what I needed. You explained the purpose of the video in few secs at the start so I didn't waste time even though i came down just to type all of this out, Thanks!

[@Chef-1707]

Thats super helpful and much appreciated. Love all the little tips that make things so much easier.

[@Computergaga]

Great! Happy to help.

[@ampmskm]

Thank you Sir, you made my day ..

[@Computergaga]

My pleasure. You're welcome.

[@ianodonoghue7299]

Hi Alan very useful video. Really helpful for me when doing notes for financial statements at work. Thanks

[@Computergaga]

Excellent! Thank you Ian.

[@daohiotrollwall]

Thankyou I really like your informative videos keep going btw you helped me alot bc my IT practical is coming and i really needed this Btw i am from 8 class and love you from India keep going my blessings is with you :)

[@sasavienne]

Thanks for the very useful and informative tutorials. It is so kind of you to share this valuable knowledge. You deserve my respect and my unlimited gratitude.

[@Computergaga]

Thank you Salim.

[@chascarpenter5006]

Had to watch it several times to get it to sink in, but doubt i will ever have to use it in my data base, however, I am still trying to find the answer in your videos to adding (304) to a number in column A to a figure & getting the added number of the two in B, I have subscribed to your channel & find it easy to learn from you, Thank you.

[@Computergaga]

Thank you Chas.

[@dickyrock1]

Thanks man, good simple video, appreciate it.

[@Computergaga]

Thank you.

[@ICCHighlights07]

Thanks, I was stuck in this step. Your video help me out from pickle.

[@Computergaga]

Excellent. Great to hear that it helped.

[@dadwarkh]

Hi. thanks for the informative video, I was expecting a formula that may turn the number to the text noun of it. like 4 becomes four. which may be used to automate the total value of bills.

[@RajKumar-ku4qz]

Thanks for this is useful text function.

[@Computergaga]

You're welcome Raj, thank you.

[@johnefokwu6342]

Thanks man. Simple and effective presentation

[@Computergaga]

Great to hear. Thank you, John.

[@laskaralam9119]

Thanks a lot

[@Computergaga]

You're welcome 👍

[@abhishekgaurav2012]

Thanks

[@Computergaga]

My pleasure Abhishek.

[@krismaly6300]

i ENJOYED WATCHING THIS VIDEO AND RECOMMEND OTHERS TO WATCH. Thanks for educating the community and appreciate your volunteer-ship Question Is there no function in Excel to REVERSE a word or string like ABC to CBA 'How are you' to 'uoy era woH' Thanks a lot

[@Computergaga]

I do not believe there is, I'm afraid.

[@padamsinh]

Hi I am working on two sheets but there is some cells are getting correct answer and other are showing NA error i am not able to sure both refrence file format is number or Text How i can change format of data

[@Yumi-fb2rw]

ah damn thanks man Ive been trying to add text to a file I needed, kinda used the IF funktion to do that and then added TEXT into it then SUM. That took so long and didnt even work in the end

[@Computergaga]

No worries. I hope it is all working now.

[@conorayaan5691]

Dunno if anyone gives a damn but if you are bored like me during the covid times then you can stream all of the latest series on InstaFlixxer. Have been watching with my girlfriend during the lockdown =)

[@tatumblaine9089]

@Conor Ayaan Yea, I've been watching on InstaFlixxer for since november myself :D

[@majidsiddique8227]

Excellent

[@Computergaga]

Thank you Majid.

[@ziaulhaqexecutiveengineer2455]

Thank you.

[@Computergaga]

You're welcome. Thank you.

[@Lemo-o3d]

Hi! When I wrote down all the formula as exactly as you do in the video my dates show off like this "dd/mm/1974" :D :D I did the same thing with you! What's wrong in my formula ? Thank you :)

[@Lemo-o3d]

I got it! It was because of my computer's language selection :D

[@Computergaga]

Nice work, Ahmet.

[@sachinrv1]

Thanks for sharing

[@Computergaga]

You're very welcome Sachin.

[@unTOLD-IT]

Is there shortcut for text function in 2007 version ?

[@Computergaga]

No shortcut, but it is available for use.

[@MrDazza124]

Hi Alan, Excellent informative videos. Please keep doing them. I have signed up to emails and the e-book. I'm a newbie but picking things up with your helpful videos. Can I ask if you have copies of example worksheets with formulas so that I can follow the steps in an interactive way whilst watching the videos. Also how do you insert /split a cell without affecting the cells underneath that already have formatting? When I try it affects the below formatting especially if the cells have been merged/centred. Apologies if this is so basic but I'm just starting out at age 50 so a bit late to all this. My intention is to learn how to produce both weekly and monthly production schedules which include job numbers, people, job status etc.Eventually I will calculate dates which are over due and total jobs per month/year. Eventually link monthly/ yearly to a graph but haven't got round to graphs yet lol Regards Darren

[@Computergaga]

Hi Darren, Good to hear from you. I'm glad you find the videos useful. I have a structured course to learn Excel quickly with downloadable files and challenges etc. You can enrol here - www.udemy.com/excel-2013-superhero-course/?couponCode=LIVE10 Not completely sure on your question. Might have to unmerge the cells first, before inserting additional columns or merging other cell ranges. May be a bit of a rubix cube layout. Sounds like you have a plan. You can use Conditional Formatting to highlight dates that are overdue (might do a video in a few days on it), and PivotTables for your total jobs by month/year. Sounds awesome.

[@compscript7973]

Not acceptable for a mass amount of data with many formats. I want to take special formatting and add text to it so that it never ever changes formatting.

[@locochon9268]

I just want add == to a cell without put "==", that's possible?

[@mahaboobhossain5076]

its helpful

[@Computergaga]

Excellent! Thank you.

[@SuperNukki]

I have a CSV file, i need to add "0" at first number entries in the cell, for example i already type 0812990088, as default excel only read 812990088 (without 0) then i tried to add ( ' ) in front of 0 and become like this '0812990088. after i saved the CSV and re-open it again, 0 in the front of numbers not appear, even i changed format cells as a text. How to keep 0 still appear on CSV format ? Please advise sir

[@Computergaga]

I have replied to your email Nuki.

[@SuperNukki]

Computergaga, million thanks Sir. Have a nice weekend :)

[@Computergaga]

You're welcome Nuki.

[@shashankgupta8723]

Sir, if in case you tell here so we can also see to it

[@kevinmurphy4946]

FIRE

[@Computergaga]

🔥

[@SamoYo1]

Thank you so much

[@Computergaga]

You're most welcome, Sam.

[@MohamedAlaa-lh6mo]

Thanks

[@Computergaga]

You're welcome, Mohamed. Thank you.