ExcelBanter - how do I combine cells (names)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I combine cells (names) (https://www.excelbanter.com/excel-discussion-misc-queries/30941-how-do-i-combine-cells-names.html)

fiji41

how do I combine cells (names)

I have first names in Column A and last names in column B. How do I combine
them?

Gary's Student

If A1 is Gary and B1 is Weaver then put =A1&B1 in C1.
--
Gary's Student

"fiji41" wrote:

I have first names in Column A and last names in column B. How do I combine
them?

Bob Phillips

Make it readable

=A1&" "&B1

<G

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Gary's Student" wrote in message
...
If A1 is Gary and B1 is Weaver then put =A1&B1 in C1.
--
Gary's Student

"fiji41" wrote:

I have first names in Column A and last names in column B. How do I
combine
them?

All times are GMT +1. The time now is 12:04 PM.