Lengkap

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

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,CHAR(235),"e"),CHAR(201),"e"),CHAR(174),""),CHAR(233),"e")

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

Thanks

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, PHP, Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 85 ulasan ) Eghm, United Kingdom

ID Projek: #17408143

Dianugerahkan kepada:

gsanggara

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 Lagi

$15 USD dalam 0 hari
(17 Ulasan)
3.6

20 pekerja bebas membida secara purata $33 untuk pekerjaan ini

schoudhary1553

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 Lagi

$50 USD dalam sehari
(291 Ulasan)
7.6
avinav606lx

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 Lagi

$30 USD dalam 3 hari
(165 Ulasan)
6.5
abhinovpankaj

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 Lagi

$30 USD dalam sehari
(64 Ulasan)
5.5
usmanhassan123

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

$30 USD dalam sehari
(38 Ulasan)
5.7
archanaoswal

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 Lagi

$40 USD dalam sehari
(60 Ulasan)
5.6
$30 USD dalam sehari
(20 Ulasan)
5.1
nelumindralal

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 Lagi

$50 USD dalam 2 hari
(23 Ulasan)
4.2
sloker18

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 Lagi

$30 USD dalam sehari
(28 Ulasan)
4.3
graphicdoll

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 Lagi

$60 USD dalam sehari
(3 Ulasan)
3.8
Mfaisalshahzad00

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 Lagi

$100 USD dalam sehari
(11 Ulasan)
3.4
ranahashim

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.

$30 USD dalam sehari
(2 Ulasan)
2.7
markpashalis

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 Lagi

$10 USD dalam sehari
(2 Ulasan)
2.5
Nicecreator

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.

$25 USD dalam sehari
(8 Ulasan)
2.3
alxalexfs

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

$15 USD dalam sehari
(1 Ulasan)
1.7
paulodayto08

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 Lagi

$25 USD dalam sehari
(1 Ulasan)
0.8
iamtahirmalik

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. ........

$20 USD dalam sehari
(3 Ulasan)
2.9
nishantha041

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

$13 USD dalam sehari
(1 Ulasan)
0.0
$35 USD dalam 2 hari
(0 Ulasan)
0.0
ykgljain

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 Lagi

$15 USD dalam sehari
(0 Ulasan)
0.0