How to segregate a single record into separated cells

		Microsoft Office Forums > Microsoft Excel > Excel
How to segregate a single record into separated cells

FAQ

Thread Tools

Display Modes

09-08-2011, 11:16 PM

macropod

Windows 7 64bit How to segregate a single record into separated cells

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,379

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]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to record files in Journal	oldnumber11	Outlook	0	07-13-2011 09:24 AM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
adding text on a separated column line	ahmet1985	Word	0	03-27-2010 07:10 AM
Record Retention based off Category	jerelp	Outlook	0	02-18-2010 08:06 AM
Returning Next Record to the top	bordercollie10	Mail Merge	0	02-26-2009 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:40 PM.