Thread: How to segregate a single record into separated cells
View Single Post
 
Old 09-08-2011, 11:16 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,379
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Kim,

In D5: =LEFT(A5,FIND(",",A5)-1)
In E5: =TRIM(SUBSTITUTE(LEFT(A5,LEN(A5)-3),D5 &",",""))
In F5: =RIGHT(A5,2)
in G5: =PROPER(E5)&" "&F5&" "&PROPER(D5)

Copy down as far as needed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote