From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

CHAR and CODE

CHAR and CODE

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

CHAR and CODE

“

- I think it's important to show you the CHAR and CODE functions. Now, in cell B2, I want the text "date greater than or equal to 10 days", but I want the true mathematical symbol for greater than a equal to. One way to do that, with my cursor in that cell I'm going to double click in it and put my cursor right there so I can edit. And I'm on the insert tab and I'm going to go over to symbols and symbol greater than or equal to is right there. But also, we have a lot of symbols that we could scroll through looking for this if it wasn't one of the recently used symbols and that's one reason why I want to show you this. But right here, we can go ahead, click on it and insert it, close and then get rid of this. Okay, I don't want a space on both sides. Enter. Date greater than or equal to 10 days. But now let's say I've pasted in Noel's name and I want to get that E. Okay, with the dots above it. I don't want…

Contents