Results 1 to 6 of 6

Combining 2 columns into one without losing its format

Threaded View

  1. 10-24-2022, 09:39 PM #1
    fen-fen
    fen-fen is offline
    Registered User
    Join Date
    10-24-2022
    Location
    Tokyo
    MS-Off Ver
    MS Office 2021
    Posts
    3

    Combining 2 columns into one without losing its format

    Dear All,

    I need help combining 2 columns into one without losing its formatting.
    One column has date format and the other one is number format.
    I attached the sample date. In column D, I need to show it the same format as the column from which I pulled.
    Can anyone help me?

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Combine 3 Columns into 1 Cell - Without Losing Format
    By watson150 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2020, 08:53 PM
  2. Combining multiple rows into one column without losing data
    By ChristSeeker72986 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-25-2016, 11:19 AM
  3. Text to Columns losing date format
    By PaulG2015 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2016, 10:48 AM
  4. Combining multiple cells into one (without losing data) if the rest of the row is equal
    By PatrickShow in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2013, 02:57 AM
  5. Combining Contents of multiple cells into 1 cell - without losing data
    By schiffs in forum Excel General
    Replies: 1
    Last Post: 06-05-2013, 08:06 AM
  6. [SOLVED] Combining two columns while retaining the data format of first column
    By dr_phd1 in forum Excel General
    Replies: 1
    Last Post: 11-05-2012, 12:52 AM
  7. [SOLVED] Combining two cells, losing formats
    By johnlynches in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2012, 12:15 AM

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