View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mary T[_2_] Mary T[_2_] is offline
external usenet poster
 
Posts: 1
Default Grabbing text from just part of a cell


Hi all,

I have sheets that come in that include a cell that says, for instance
'Subject no.: 5'. How would I grab just the '5' part of that cell?

Help appreciated, thanks

--
Mary
-----------------------------------------------------------------------
Mary T's Profile: http://www.excelforum.com/member.php...fo&userid=3015
View this thread: http://www.excelforum.com/showthread.php?threadid=49834