+ Reply to Thread
Results 1 to 4 of 4

Add data in cell A to the front of data in cellB

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    Werstchester, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Add data in cell A to the front of data in cellB

    I imagine this is really simple for one of you experts but a quick search yielded no results. I am trying to import a csv file containing contact information

    The file I am importing from lists telephone information in 2 columns. Column a has the area code and column b has the other 7 digits of the phone number. The correct format is all 10 digits in a sigle column. It seems to me the bezst way to accomplish this would be to somehow merge the data in these cells but it has been a while since I used excel and my old brain seems to have forgotten some of its tricks.

    Thanks in advance to anyone who is able to help me out here. It is greatly appreciated.

    Thanks,

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Add data in cell A to the front of data in cellB

    Try this..

    =A1&B1

    if you need a space in between:

    A1&" "&B1

    with dash:

    A1&"-"&B1
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    01-30-2014
    Location
    Werstchester, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Add data in cell A to the front of data in cellB

    Exactly perfect 100% what I wanted thank you sir

    I have added to your rep as well.

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Add data in cell A to the front of data in cellB

    You're welcome and thank you for your feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If data entered in cell, on same row, copy and paste data from other cells to front sheet
    By Christopher135 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2013, 06:34 PM
  2. [SOLVED] Button which links the front page to another page depending on a data validation cell valu
    By greg19 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-12-2013, 03:59 AM
  3. CellA = CellB only if CellB has text
    By buddhajb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2008, 01:34 PM
  4. cell has junk in front of my data!???!
    By wadeh2o in forum Excel General
    Replies: 6
    Last Post: 12-09-2006, 06:28 PM
  5. Feeding Sorted Data to Front Tab
    By neospooky in forum Excel General
    Replies: 4
    Last Post: 01-31-2005, 07:05 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