Thread: Picking out certain data from a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Picking out certain data from a cell
Hi Jade,

Am Wed, 9 May 2012 08:32:06 +0000 schrieb jade89:

#01-034 EAST AVENUE

the string in A1, then try:
=LEFT(A1,FIND(" ",A1)-1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote