Use other utility text functions: LEN, REPT, VALUE, TEXT

- [Voiceover] We're looking at a worksheet called More Text…and in this movie we want to show you…four different functions, text functions,…and they're listed in column A.…There's a function called TEXT,…there's one called VALUE, there's one called LEN,…think of the word length, we've got that to the right,…and there's a function called REPT,…think of the word repeat.…In cell A1, you can imagine seeing something…like this on an invoice, you bought 425 items.…But as we double-click here, and you can see it…in the formula bar too,…this is two different text strings…combined with the data in cell A4.…

It works perfectly, not a problem.…Spacing is there, if the number's bigger for example…it'll still work, so I make that be,…you know, for the moment 1400, that works fine too.…Undo that, command Z.…Now in the second entry here this is set up,…but it's not quite complete yet.…What we want to be able to do here…is to multiply those two items…and put it into the list here.…So following the double quote there…I'm going to put in the ampersand symbol, meaning and,…