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

Attached Files

Query102.xls (19.0 KB, 15 views)

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]

check the workbook attached..

Attached Files

Copie a Query102.xlsx (10.3 KB, 13 views)

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