Delete A:B, the live formulas in C will change to #REF! errors.You can immediately press Ctrl+Z (or Alt+Backspace) to undo the deletion. This tells you that you have a formula that points to cells(s) that are no longer there. Gotcha: If you delete columns A and B while column C still contains formulas, all the formulas will change to #REF! errors. There are also UPPER and LOWER functions.(Some people suggest entering the last name as Mc Cartney, with a space to prevent this problem.) Note: If you like PROPER, consider UPPER and LOWER to convert text to upper or lower case. After using the PROPER function, you will have to manually fix any names that have interior capital letters. This will work for all your names except names with interior capitals, such as Paul McCartney or Dave VanHorn. =PROPER(A2&" "&B2) will convert the names to proper case.
Copy the formula down to all the cells in the range.Īdditional Details: To convert NORAH JONES to Norah Jones, you use the PROPER function.To insert a space between the first name and the last name, join cell A2, a space in quotes, and cell B2, using the formula =A2&" "&B2.You change the formulas in column C to values before deleting columns A and B. Strategy: You can use the ampersand (&) as a concatenation operator in a formula in column C. You want to join A2 and B2 into a single cell.I want to merge these two columns into one column. Problem: I have data with first names in column A and last names in column B.
0 kommentar(er)
