#1
|
|||
|
|||
How to segregate a single record into separated cells
Hi all,
Please advice how to segregate from a single Excel record into separate cells and re-format cell again into a combined record, as per attached .xls file. I've tried the VLOOKUP but can't figure out if the record has a multiple name. Thanks in advance, Kim |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
check the workbook attached..
|
#4
|
|||
|
|||
Hi Paul and Catalin,
Both your advices are neat and crisp.. ... and with variety too. Again, thanks a lot. Another solved case here to both your credit. And another novice here getting a much needed lift. Till next case then? Cheers, Kim |
|
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 |