Learn Excel from Bill Jelen with this daily 2 minute video podcast.
Bill has a worksheet where he's building text references and then hopes to evaluate the resulting SUM function. Instead, I suggest using INDIRECT to add up the three individual cells. Episode 727 shows you how.
Labels: Concatenation, formulas
posted by Bill at 9:00 AM
Many people were missing from the map on last Monday's podcast. Did I miss their entries? No! I use a common Excel trick to keep leading zeroes, but this confused MapPoint. In today's podcast, we take a look at other ways to keep leading zeroes in Excel. Episode 721 shows you how.
Labels: Concatenation, Leading Zeroes, Maps, Number Formats
posted by Bill at 9:00 AM
Mike from Kansas City asks if there is a way to take words from many adjacent cells and merge them into a single cell. Episode 578 shows many approaches to this problem.
Labels: Concatenation, Paste Special
posted by Bill at 9:00 AM
JJ writes in with a question from Alaska. His home office keeps sending him data with airline in column A and flight number in column B. In order to use this data, he needs to join both values into a single cell. Episode 523 shows how to use concatenation to solve the problem.
Labels: Concatenation
posted by Bill at 9:00 AM
If you try to use the concatenation character to join text with a date, you will not get the results that you expected. Episode 414 shows you how to modify the formula to properly format the date.
Labels: Concatenation, dates, Formatting, Text
posted by Bill at 9:00 AM
How to join text from two columns using the concatenation character. Episode 412 shows you how to do concatenation, plus how to convert upper case to proper case on the fly.
Labels: Concatenation, Text
posted by Bill at 9:00 AM
Today's tip comes from Dave in Columbus, Indiana. Dave was at my Power Excel seminar last week and passed along a better way to invoke the Paste Special Values command. In the process of showing Dave's trick, I also talk about joining text using the concatenation operator, changing text from upper case to proper case, copying a formula by double-clicking the fill handle, using Ctrl+z to undo. Episode 394 shows you how.
Labels: Concatenation, keyboard shortcuts, Paste Special, shortcuts
posted by Bill at 9:00 AM
