Merging columns

Brendon · Mar 18th, 2002, 06:31 AM

Hello

I feel a little silly asking this questionn because I asked it proeviously and now can't find the answer.

I have 2 columns. Column A has first names (let's say 'John'). Column 2 has last names (let's say 'Smith'). Can I merge the columns so that the 1 resulting column has the full name appropriately formatted (i.e. John Smith)?

Thanks for any help.

Nigel Martin · Mar 18th, 2002, 06:41 AM

Hello Bendon,
Say A1=John and b1=Smith
In C1 enter =A1" "&B1
then simply copy it down and delete the original columns if necessary.

Nigel Martin · Mar 18th, 2002, 06:44 AM

PS
Sorry I forgot an &
The formula should read =A1&" "&B1 - entered into C1
Between the speech marks is a space.

Hope this hepls.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 06:31 AM	#1
Brendon New Member Join Date: Mar 2002 Posts: 15	Hello I feel a little silly asking this questionn because I asked it proeviously and now can't find the answer. I have 2 columns. Column A has first names (let's say 'John'). Column 2 has last names (let's say 'Smith'). Can I merge the columns so that the 1 resulting column has the full name appropriately formatted (i.e. John Smith)? Thanks for any help.

Mar 18th, 2002, 06:41 AM	#2
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Hello Bendon, Say A1=John and b1=Smith In C1 enter =A1" "&B1 then simply copy it down and delete the original columns if necessary.

Mar 18th, 2002, 06:44 AM	#3
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	PS Sorry I forgot an & The formula should read =A1&" "&B1 - entered into C1 Between the speech marks is a space. Hope this hepls.