+ Reply to Thread
Results 1 to 5 of 5

Need help merging 2 cells without losing certain information

  1. 09-24-2013, 03:02 PM #1
    psgolfer32381
    psgolfer32381 is offline
    Registered User
    Join Date
    12-17-2012
    Location
    Carrollton, TX
    MS-Off Ver
    Excel 2010
    Posts
    20

    Need help merging 2 cells without losing certain information

    Hi,

    I have 2 columns of information, one is text and the other is numbers. The numbers are 4-digits, several with zeros at the beginning. When I simply use =A1 & B1, which is what I would normally do (column A is text, all the same, and column B is numbers), the leading zeros are being stripped away. I have not been able to use any method that I know to make this NOT happen. I have to have the zeros in there. For what I'm using this for, they all have to have the same number of digits.

    Help!

    I've attached the spreadsheet. I have played around with a few things, and I haven't removed a couple columns.

    Thank You!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-24-2013, 03:08 PM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need help merging 2 cells without losing certain information

    Use

    =A1&TEXT(B1,"0000")
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 09-24-2013, 03:11 PM #3
    L-Drr
    L-Drr is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Need help merging 2 cells without losing certain information

    you could recreate the zero's...
    =IF(LEN(B1)=4,A1&B1,IF(LEN(B2)=3,A1&"0"&B1,... etc.
    When I say semicolon, u say comma!
    Reply With QuoteRegister To Reply
  4. 09-24-2013, 03:13 PM #4
    L-Drr
    L-Drr is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Need help merging 2 cells without losing certain information

    Quote Originally Posted by Ace_XL View Post
    Use

    =A1&TEXT(B1,"0000")
    lol yeah nevermind my devious ways
    Reply With QuoteRegister To Reply
  5. 09-24-2013, 03:15 PM #5
    psgolfer32381
    psgolfer32381 is offline
    Registered User
    Join Date
    12-17-2012
    Location
    Carrollton, TX
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Need help merging 2 cells without losing certain information

    Thank you!!! I was trying to do something similar to that with the formatting, but I was beating my head against a wall.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merging Multiple Rows in a Column without losing text
    By carlc711 in forum Excel General
    Replies: 1
    Last Post: 07-10-2013, 07:05 PM
  2. [SOLVED] Merging cells to quickly add information to entire column
    By Erik Thomas in forum Excel General
    Replies: 2
    Last Post: 11-13-2012, 02:34 PM
  3. Merging cells without losing zeros
    By mrwd40 in forum Excel General
    Replies: 2
    Last Post: 01-29-2010, 04:52 PM
  4. Merging cells with common information
    By babarorhum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2008, 04:29 PM
  5. Merging information from multiple cells or worksheets
    By MAPADMIN in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-29-2005, 01:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1