Merging columns
Merging columns
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Merging columns

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Hope this hepls.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com