Dueling Excel 140

Stock Symbol (Last 2 Words)

DESCRIPTION

One cell has a security name, ticker symbol, then price. The complicated part is that the security name might have 3, 4, or 5 words. How can you extract the last 2 words into new cells and everything else as the security name? Bill and Mike try Flash Fill, a VBA function, and a long formula to solve the problem.

WORKBOOKS




Be the first to comment

Leave a Reply