+ Reply to Thread
Results 1 to 5 of 5

Merge Formula

  1. 08-14-2020, 07:45 AM #1
    kris01
    kris01 is offline
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    85

    Merge Formula

    Hello,

    How do i quickly merge the two cells below. I want to see the same format on the value after the cells have been merged.

    Many thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-14-2020, 07:56 AM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Merge Formula

    Please try

    =B2&TEXT(C2,"£#,0.00")
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 08-14-2020, 08:00 AM #3
    kris01
    kris01 is offline
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    85

    Re: Merge Formula

    perfect thank you
    Reply With QuoteRegister To Reply
  4. 08-14-2020, 08:17 AM #4
    kris01
    kris01 is offline
    Registered User
    Join Date
    05-22-2019
    Location
    london
    MS-Off Ver
    Office 365
    Posts
    85

    Re: Merge Formula

    hi just a quick question. If wanted the value to be in bold. What would the formula be then?
    Reply With QuoteRegister To Reply
  5. 08-14-2020, 11:41 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Merge Formula

    You cannot bold part of a cell contents like that, you would need VBA
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Can you have a macro that exports individual mail merge and names based on merge fields?
    By taylorsm in forum Word Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2018, 10:54 PM
  2. [SOLVED] assistance to merge 2 formula trim, substitute, len as one formula
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-06-2017, 05:37 AM
  3. Is this possible: Mail Merge/VBA to merge PDFs into one document based on cell values
    By lukestkd in forum Excel General
    Replies: 0
    Last Post: 06-24-2015, 02:34 AM
  4. Email merge from excel merge file using pre-saved word template
    By d_max_c in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2014, 12:33 PM
  5. Email Merge with variable merge records break by client level
    By sss047 in forum Word Formatting & General
    Replies: 0
    Last Post: 04-15-2011, 04:25 AM
  6. mail merge excludes my headers and critical data in Word merge
    By Nix in forum Excel General
    Replies: 0
    Last Post: 04-21-2006, 03:40 PM
  7. Merge =( formula should retain fraction type numbers after merge.
    By Aubrey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-09-2006, 03:40 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