View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Remove number from string in excel

=MID(Sheet2!A1,27,99)*1

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Hi,

I have the following string: "No. of Unsuccessful Calls: 1"
I would like to link to the number in this cell only from sheet one (this
string is in cell A1 of sheet 2)

Thanks
C