Combining data from 3 fields (colums)

[Guest]

I have a list of doctors on a spread sheet. Column A is "First Name", Coumn B is "Last name" and Column C is "Degree". I would like to combint the three columns to in Column D to read Joe Smith, MD. Note that I would have to add comma after last name. Any help is greatly appreciated.

 

[Andy B]

Hi

Try this:

=A1&" "&B1&", "&C1

Andy.

I have a list of doctors on a spread sheet. Column A is "First Name",

Coumn B is "Last name" and Column C is "Degree". I would like to combint
the three columns to in Column D to read Joe Smith, MD. Note that I would
have to add comma after last name. Any help is greatly appreciated.

 

[Frank Kabel]

Hi
try
=A1 & " " & B1 & ", " & C1

--
Regards
Frank Kabel
Frankfurt, Germany

I have a list of doctors on a spread sheet. Column A is "First

Name", Coumn B is "Last name" and Column C is "Degree". I would like
to combint the three columns to in Column D to read Joe Smith, MD.
Note that I would have to add comma after last name. Any help is
greatly appreciated.

 

[RagDyeR]

=A1&" "&B1&", "&C1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a list of doctors on a spread sheet. Column A is "First Name", Coumn
B is "Last name" and Column C is "Degree". I would like to combint the
three columns to in Column D to read Joe Smith, MD. Note that I would have
to add comma after last name. Any help is greatly appreciated.