From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using the utility text functions: TEXT, REPT, and LEN

Using the utility text functions: TEXT, REPT, and LEN

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using the utility text functions: TEXT, REPT, and LEN

- Sometimes when you get data from other sources you've got numbers that should have leading zeros. Usually they're code-type numbers. We've got some entries in column B. We really want them to look like how they appear in column C right now. We can do this with a function called TEXT. =TEXT. I'm using it here in cell A2, so let's pick up that data from cell B2, comma, and notice the pop-up tip below it says format_text. We want to format this as if it were a number. If you're familiar with formatting techniques... If you've worked at the character level in setting up formats, zero character, you would know, represents a number. 000... 000000. We want this to be displayed as a six character number. Zeros are like placeholders for numbers, so the answer we get here is what we would want. Make the column a little bit wider so we can see that. That's all we're doing. Take the value that's in B2. Format it to coincide with this layout. It will automatically make that entry be…

Contents