Thread: How Do? Take two words in cell 1 and slpit them to cell 2 & 3
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
jermsalerms
 
Posts: n/a
Default How Do? Take two words in cell 1 and slpit them to cell 2 & 3

Last Name
=REGEX.MID(A5,"\w+((,?\s)(Jr|Sr|II|III|IV|M\.?D|PH \.?D)(\.?))?$")

seems to work

I took out the string in red

=REGEX.MID(A5,"\w+((,?\s)(Jr|Sr|II|III|IV|M\.?D|(? i)PH\.?D)(\.?))?$")


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=498521

Reply With QuoteReply With Quote