Thread: sperate from the space, in text, in the same cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fam via OfficeKB.com Fam via OfficeKB.com is offline
external usenet poster
  
Posts: 5
Default sperate from the space, in text, in the same cell
Hi..
Is there a way tpo seperate or extract out first or last name from the same
cell?
for example, if in cell A1 we have John Smith, can I able top extract out
just John or Smith in cell B1?
Any help will be appreciated
thx

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote