+ Reply to Thread
Results 1 to 5 of 5

Concatenate and change format

  1. 09-09-2020, 08:51 PM #1
    minhys1
    minhys1 is offline
    Spammer
    Join Date
    06-29-2020
    Location
    Vietnam
    MS-Off Ver
    2013
    Posts
    95

    Concatenate and change format

    Concatenate 2 or multiple cell and change format
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-10-2020, 12:48 AM #2
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,713

    Re: Concatenate and change format

    Hi minhys1,

    Try below code …
    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name
    Reply With QuoteRegister To Reply
  3. 09-10-2020, 03:45 AM #3
    minhys1
    minhys1 is offline
    Spammer
    Join Date
    06-29-2020
    Location
    Vietnam
    MS-Off Ver
    2013
    Posts
    95

    Re: Concatenate and change format

    nankw83, yes , your code work good. If using VBA function, it will be better
    Reply With QuoteRegister To Reply
  4. 09-10-2020, 06:08 AM #4
    nankw83
    nankw83 is offline
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,713

    Re: Concatenate and change format

    Thanks minhys1 for the reps

    As far as I know, you can NOT have different text formatting in an excel function
    Reply With QuoteRegister To Reply
  5. 09-15-2020, 10:17 PM #5
    minhys1
    minhys1 is offline
    Spammer
    Join Date
    06-29-2020
    Location
    Vietnam
    MS-Off Ver
    2013
    Posts
    95

    Re: Concatenate and change format

    nankw83, thank you support me
    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. [SOLVED] concatenate with date format...
    By Quint6778 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2017, 11:05 AM
  2. [SOLVED] need to change format and concatenate 4 column to one
    By spriggan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2016, 11:38 PM
  3. Concatenate VBA that keeps currency format
    By isasa74 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2015, 04:30 AM
  4. Concatenate but keep currency format
    By k1989l in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 06-18-2015, 09:51 AM
  5. Use format of one cell to change type of format used in conditional format
    By r.coon in forum Excel General
    Replies: 3
    Last Post: 02-24-2015, 02:58 AM
  6. Need Numbers to Concatenate to Number Format, Not Text Format
    By DJH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2014, 01:01 AM
  7. Concatenate format problem
    By kovall in forum Excel General
    Replies: 3
    Last Post: 06-21-2007, 04:04 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