View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ajw150
 
Posts: n/a
Default Extracting data from a cell - please help


Hi all,

I have a column of cells of address data. The data contains house
number, street name, town and postcode. Is it possible to extract the
postcode from the line easily? and place it into another cell.

Thanks

Andrew


--
ajw150
------------------------------------------------------------------------
ajw150's Profile: http://www.excelforum.com/member.php...fo&userid=8020
View this thread: http://www.excelforum.com/showthread...hreadid=546623