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.
Using the data for Exxon from the yahoo link below: Price Target Summary Mean Target: 90.50 Median Target: 90.00 High Target: 105.00 Low Target: 64.00 No. of Brokers: 18 There are 18 estimates. Mean = sum of estimates / 18 Median = middle estimate. Rank them top to bottom, select the middle value. XOM's closing price on Friday was $73.90, so most analysts forecast a gain.