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
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 - combine 4 formula into 1
Delivery time :
0 day
Available time :
Imediately
#UNQUOTE#
I am very interesting to work on your project.
Looking forward to hearing from you soon as I am available to work on it.
Best Regards,
GS Anggara
$15 USD en 0 día
4,9 (28 comentarios)
4,2
4,2
19 freelancers están ofertando un promedio de $33 USD por este trabajo
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 professionals working here with 100% results and more creative and renovative ideas for our clients !
We have worked on several similar projects before!
We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel, PHP, Visual Basic
We have worked on 350+ Projects. Please check the profile reviews
Feel free to message us to discuss briefly about your project !
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 and work on your project.
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 to use.
Ping me to discuss more
Thanks
A
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 my skills.
Please review my profile and thank you for considering me for your project.
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 various constraints
- Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites.
- Buy and sell bitcoins on Coinfloor and GDAX using respective APIs.
- Built a POS and inventory management system.
- Built a hotel price comparison that pulls data using the website's API.
You can see the reviews of the same in my profile.
Thanks, Archana
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 a subject expert matter and has a strong knowledge with MS excel. Please work with me and i'll make sure that i can do that in one day.
Also, currently working with financial reporting using my expertise and certification in Microsoft Excel. I am Knowledgeable with Ms Excel Charts and Formatting.
Communication is not a problem because I know how to communicate both verbally and writing using English language.
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
regards
Thushara
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 deliver you project timely and there will be no Delay in my Work.
I will start work ASAP.
I am here for long term work Relationship.
So will give you 101% best output from my end, So that you consider me for Future Job.
My all skills matched with your requirements, So I can easily help you to complete this project.
Kindly let me know once you are here, So we can discuss further in details.
Thanks and Regards,
Inderjeet
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% satisfied client.
I am regularly doing following kind of tasks:
I have four separate formulae in Excel that I am trying to combine into one cell.
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.
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.
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.
........
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, I would be able to.
Please send me some sample data for 'FinalisedSource', 'Instructions', 'New Titles' sheets, I will combine and send the final one.
Doesn't look like a big job, but hope I am not wrong :).
I think this can be scripted/programmed as well outside the domain of excel, but can comment confidently only after seeing the sample data and understanding the intent.
Thanks and Regards
Yogesh
