Færdiggjort

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

Evner: Dataindførsel, Databehandling, Excel, PHP, Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 85 bedømmelser ) Eghm, United Kingdom

Projekt ID: #17408143

Tildelt til:

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 Flere

$15 USD in 0 dage
(17 bedømmelser)
3.6

20 freelancere byder i gennemsnit $33 på dette job

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 Flere

$50 USD på 1 dag
(291 bedømmelser)
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 Flere

$30 USD in 3 dage
(165 bedømmelser)
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 Flere

$30 USD på 1 dag
(64 bedømmelser)
5.5
usmanhassan123

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

$30 USD på 1 dag
(38 bedømmelser)
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 Flere

$40 USD på 1 dag
(60 bedømmelser)
5.6
$30 USD på 1 dag
(20 bedømmelser)
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 Flere

$50 USD in 2 dage
(23 bedømmelser)
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 Flere

$30 USD på 1 dag
(28 bedømmelser)
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 Flere

$60 USD på 1 dag
(3 bedømmelser)
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 Flere

$100 USD på 1 dag
(11 bedømmelser)
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 på 1 dag
(2 bedømmelser)
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 Flere

$10 USD på 1 dag
(2 bedømmelser)
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 på 1 dag
(8 bedømmelser)
2.3
alxalexfs

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

$15 USD på 1 dag
(1 bedømmelse)
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 Flere

$25 USD på 1 dag
(1 bedømmelse)
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 på 1 dag
(3 bedømmelser)
2.9
nishantha041

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

$13 USD på 1 dag
(1 bedømmelse)
0.0
$35 USD in 2 dage
(0 bedømmelser)
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 Flere

$15 USD på 1 dag
(0 bedømmelser)
0.0