+ Reply to Thread
Results 1 to 4 of 4

Combining formulas

  1. 06-13-2016, 11:29 AM #1
    airedale360
    airedale360 is offline
    Registered User
    Join Date
    06-03-2013
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    41

    Combining formulas

    hello, i have 3 formulas i would like to combine into one large one so i do not need to do this in three steps. i keep getting errors so i know i am missing something. here are my formulas they will need to go in this order in order for the results to show correctly.\

    =((SUBSTITUTE(SUBSTITUTE(E2,"&",""),"-",""))) - i am removing - and & to data
    =LEFT(CONCATENATE(G2),30) - data only shows 30 characters
    =H2&" "&F2 - combining the result above and merging with another cell.

    can this be combined into one long formula? Also what do i do to apply this to an unknown amount of data? i dont want to drag the formula down 1,000 rows if i dont have too.
    Reply With QuoteRegister To Reply
  2. 06-13-2016, 11:52 AM #2
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Combining formulas

    Combining them should give you this:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    if it's F2 which is the 'other cell' to be added on the other end of the result.

    If it's H2 you want to have before the result, then use:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    With this entered in the top row of a range of data, hold down the Alt key then double-click the drag-handle at the bottom right of the cell - that will auto-fill the formula down to the next blank row.
    Last edited by Aardigspook; 06-13-2016 at 11:54 AM.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
  3. 06-13-2016, 12:04 PM #3
    airedale360
    airedale360 is offline
    Registered User
    Join Date
    06-03-2013
    Location
    US
    MS-Off Ver
    Excel 2016
    Posts
    41

    Re: Combining formulas

    That worked!!! Thank you so much.
    Reply With QuoteRegister To Reply
  4. 06-13-2016, 12:07 PM #4
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Combining formulas

    You're welcome.
    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. Combining IF AND formulas
    By hzarry in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-07-2015, 05:26 AM
  2. Combining formulas
    By wjk221 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2014, 01:17 PM
  3. Combining IF and OR formulas
    By Scuba*33 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2013, 01:11 AM
  4. Combining two formulas
    By Trax in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-20-2013, 09:31 AM
  5. Combining IF formulas
    By donyc in forum Excel General
    Replies: 4
    Last Post: 09-09-2010, 05:42 PM
  6. Combining Formulas
    By wickerman in forum Excel General
    Replies: 1
    Last Post: 12-09-2008, 10:25 AM
  7. Combining 2 formulas together.
    By cat1410 in forum Excel General
    Replies: 2
    Last Post: 08-05-2008, 02:21 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