Combine formulas in Excel

I have four separate formulae in Excel that I am trying to combine into one cell.

The first involves calculating the length of the title and if there is space up to 80 characters, adding in a predefined text:

=IF(LEN(FinalisedSource!A2&" ("&FinalisedSource!E2&")")>75,LEFT((FinalisedSource!A2&" ("&FinalisedSource!E2&")"),80),IF(LEN((FinalisedSource!A2&" ("&FinalisedSource!E2&")"))>65,(FinalisedSource!A2&" ("&FinalisedSource!E2&")")&Instructions!$B$19,IF(LEN((FinalisedSource!A2&" ("&FinalisedSource!E2&")"))>55,(FinalisedSource!A2&" ("&FinalisedSource!E2&")")&Instructions!$B$18,IF(LEN((FinalisedSource!A2&" ("&FinalisedSource!E2&")"))>15,(FinalisedSource!A2&" ("&FinalisedSource!E2&")")&Instructions!$B$17,(FinalisedSource!A2&" ("&FinalisedSource!E2&")")))))

The second is checking another sheet to see if the text is to be overridden with a custom title:

=VLOOKUP(FinalisedSource!D2,'New Titles'!A:B,2,FALSE)

The third is substituting odd characters and predefined text to blanks:

="<div align='center'><p>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FinalisedSource!A2,"www.",""),"@",""),"http://","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FinalisedSource!E2,"www.",""),"@",""),"http://","")&"<br><br>"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FinalisedSource!AH2,"www.",""),"@",""),"http://","")&"<br><br>"&IF(FinalisedSource!AJ2<>"","Ingredients:","")&FinalisedSource!AJ2&"<br>"&FinalisedSource!AK2&"<br>"&FinalisedSource!AO2&"<br>"&FinalisedSource!AP2&"<br>"&FinalisedSource!P2&"<br>"&IF(FinalisedSource!S2<>"","Brand: ","")&FinalisedSource!S2&Instructions!$B$10


If you think you can do this please place a bid.


Compétences : Saisie de Données, Traitement de Données, Excel, PHP, Visual Basic

en voir plus : concatenate excel, how to combine two if formulas in excel, how to put multiple functions in one cell in excel, combine text and number in excel, multiple formulas in one cell excel 2013, excel combine formulas from multiple cells, combine functions in excel, excel formulas, combine information excel sheets, combine lists excel, combine sheets excel, combine information excel, combine spreadsheets excel page, locking formulas excel, combine columns excel using vba, combine columns excel vba, combine data excel file worked different people, combine files excel, can combine spreadsheets excel, inputting formulas excel accounting

Concernant l'employeur :
( 85 commentaires ) Eghm, United Kingdom

Nº du projet : #17408143

Décerné à:


Hi, I have details project description & understand your needs Please find below is my quote for your project. #QUOTE# Scope of work : Combine 4 formula into single formula Proposed Milestones : USD 15 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(17 Commentaires)

20 freelance font une offre moyenne de $33 pour ce travail


Hi there, Warm Greetings We came along with your request for Combine formulas in Excel and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have profession Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(291 Commentaires)

How can I help I’m an expert in excel VBA formulas and automation with experience 5+ years Do you need to see the formulas or you want the final result, this can be automated using VBA as well and that would be easy t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(165 Commentaires)

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(64 Commentaires)

PhD in computer science having seven years of experience in Excel development and visual basics.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(38 Commentaires)

I have excellent command on MS Excel formulas. I have completed complex projects in Excel before. For instance - Create a schedule for delivery trucks pick-up and drop for optimal utilization of resources based on Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(60 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)

Hello I went through your project description. kindly contact me and send me the project details I will start it by today you may see my previous projects and reviews I look forward to hearing from you thanks re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(23 Commentaires)

I believe I can write the macro to combine the formulas, I would really like to take a look of your workbook as well for some more context, feel free to message me if you are interested, looking forward to chat further Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(28 Commentaires)

Hi, I have 4+ years of experience in Excel work . I am very Interested in your Project and also Im ready to Start Immediately. I assure you will like my Work very much and i will give you unlimited changes and I will Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)

Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)

Hi. I am available to complete your project. I have experience of google app script and excel very well. so i can complete your project quickly. Message me to discuss more and start over.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

With 10+ years of MS Access, VBA and Excel experience, I'm well equipped to provide a quality solution to your Excel formula request. Since I'm new to Freelancers, I've submitted a low bid to be able to demonstrate Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

Hi there, i understand your requirement and can do the work perfectly using my outstanding experience. Please award me the project so that we discuss it more Thank you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)

Remember that the maximum length of the content of a formula is 8,192 characters.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

Hi! I just want to know if you already have a sample file that i can work to. Can I try it first and you decide if you like my work :) I've been doing excel enhancement using vba macro for over 7 years now. and I am Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

Hey. I read your project details and I am interested in your project so please message me and we discuss about the project. Thank You, Tahir M. ........

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)

Dear sir, I can try this and feedback in few [login to view URL] contact me. Thank you

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

Hi There, Before bidding into here, I was able to combine Step 1 (The field Concatenation based on the length of 2 fields), and Step 2 (VLookup) into 1 cell. I couldn't try Third step, but with proper sample data Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)