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
|