> I am presently converting data from Q&A to import into a legal case
> managment system.
> In Q&A, the name data is kept in seperate fields for FIRST, LAST and
> MIDDLE. I have imported these no problem into Excel 7.0.
> I need to combine these fields into a SINGLE field for export with the
> format Last, First Middle and First Middle Last.
> Is there any function within Excel that will allow me to do this. Any
> help is GREATLY appreciated
> Richard E. Katz, Esq
Use the & ampersand to concatenate text.
For example, for your data with Richard in A1, Katz in B1, E. in C1
then in D1 enter the formula =A1 & C1 & B1
This cell will display RichardE.Katz
You probably want spaces between, so use the formula =A1&" "&C1&" "&B1
This will display Richard E. Katz
Use a similar formula to provide the desired comma.
Department of Chemistry, Boston College
Chestnut Hill MA 02167-3860 U. S. A.