Results 1 to 3 of 3

Merge data - 3 cells

Threaded View

Christopherdj Merge data - 3 cells 11-11-2013, 08:52 PM
gyclone Re: Merge data - 3 cells 11-11-2013, 08:54 PM
Christopherdj Re: Merge data - 3 cells 11-11-2013, 09:56 PM
  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Merge data - 3 cells

    I'm trying to merge data from 3 cells, previoulsy was 2 of which the following formula worked.

    =C2&", " &D2

    It is just names of clients. Surname with a , then I need first name a space and then middle name.
    it would be like this: Smith, James Alexander

    What do I need to do to merge C2 and D2 and E2 please
    Feeling rather brain dead at the moment, can someone help?

    thanks
    Last edited by Christopherdj; 11-11-2013 at 09:56 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. extract data from merge cells into single cells
    By meirj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-11-2013, 12:14 PM
  2. Merge data from cells on 2nd columns in which the cells of 1st column repeat
    By jagke in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2013, 01:06 PM
  3. [SOLVED] Merge Cells When Other Merged Cells Receive Specific Data
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 04-03-2012, 10:34 AM
  4. Merge two cells, keep data?
    By JapanDave in forum Excel General
    Replies: 2
    Last Post: 01-13-2011, 12:46 AM
  5. [SOLVED] Merge data from different cells
    By Jenny in forum Excel General
    Replies: 2
    Last Post: 04-01-2005, 05:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1