View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Parse data from string

=MID(A1,FIND(" ",A1,2)+1,FIND(" ",A1,5)-FIND(" ",A1,2)-1)&", "&MID(A1,2,1)

--
Regards,
Tom Ogilvy


"okrob" wrote in message
ps.com...
Can someone take a look at this post:
http://groups.google.com/group/micro...953084d4a98d93

The group isn't very active today and I need help as soon as
possible...
Thanks,
Rob