Excel Forum
Similar Content
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the for...
Calculate Percent Change in Excel
Tutorial: How to calculate the percentage amount that a value has changed in Excel. This includes q...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Ma...

Excel Magic Trick 686: Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick

See how to create a new column of values joining a value from the 1st column that contains company names and blanks and a second column with Product name. Aladin from the Mr Excel Message Board provides a cool efficient formula to solve this problem.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.