How to split a string based on â:â in MS-Excel? I want to split each word based on  :  and put the result in adjacent columns such that ABC:DCF in cell A:1 becomes ABC in cell B:1 and DCF in cell C:1 and also corresponding values in each column.
Analyst Hikes HP Price Target by 26%. FBN Securities upgrades HP to Outperform and increases its price target from $15 to $19. Feb. 24, 2017 5:15 a.m. We are upgrading shares of HP (ticker: HPQ) from Sector Perform to Outperform and increasing our price target from $15 to $19.
Retail Properties of America stock price target cut to $18 from $19 at RW Baird. 1  Mar. 13, 2017 at 7:58 a.m. 2  by Tomi Kilgore. 3  Dec. 16, 2016 at 11:12 a. 4 m. by Tomi Kilgore.