Excel formula
Good day. I am interested in an Excel formula that will take text from a specified cell and if it finds this text in another specified cell, it will remove it.
Good day. I am interested in an Excel formula that will take text from a specified cell and if it finds this text in another specified cell, it will delete it.
The price is negotiable. The site does not allow a lower price to be set.
Доброго дня. Цікавить формула ексель котра буде брати текст з вказаної ячейки і якщо знаходить цей текст в іншій вказаній ячейці то видаляє його.
ціна договірна. сайт не дає меншу поставити
-
1312 37 0 Good day.
I have experience in creating Excel tables and writing formulas.
I will be happy to collaborate.
-
1681 4 1 Hello! I have been working with Excel for a long time, by profession I am a software engineer, and at the moment I work with spreadsheets on a daily basis. I will be able to do it quickly and efficiently.
-
506 1 0 Good day!
An important point: the standard Excel formula cannot change other cells — it can only return a result in its own.
I can offer two solutions:
1) Formula — the cleaned text will be output in a separate cell.
2) VBA macro — which will actually delete the found text from another cell (by button or automatically).
Let me know which option suits you — I will do it quickly.
-
2906 72 0 Hello!
I have been working with formulas since 2008, and with VBA-Excel (macros) since 2011.
My priorities are optimizing calculations and user convenience.
A formula cannot delete text from another cell. However, it is possible to output cleaned texts into a free column using a formula, and then, if desired, replace the input data with new ones.
If the task is not a one-time job, I am ready to write code (macro) that will perform this work.
Let's do it.
-
367 1 0 I can help you with your task in Excel 😊
I will create a formula that automatically takes text from one cell and, if it appears in another, carefully removes it without damaging the rest of the data.
I will explain how it works so that you can use it yourself later if needed.
I work carefully and check the result with examples.
I can quickly connect and solve the task today. The price is 300 UAH, you can suggest your own.
-
321 6 0 Good evening, I am ready to do it quickly and efficiently, in the end I will show how it works through a video on YouTube.
-
2162 85 0 Ready to do it.
-
342 Hello. My name is Sergey. I am ready to complete your task! Write to me in private.
Current freelance projects in the category Databases & SQL
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 1 hour 25 minutes back ∙ 20 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 4 days 1 hour back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 4 days 4 hours back ∙ 19 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 7 days 4 hours back ∙ 13 proposals |
Project: Basic Setup of End-to-End Analytics (Analytics Engineer / Data Analyst)
203 USD
About us and current stack: We are a B2C web product. Currently, we have disparate data that needs to be consolidated into a single system for marketing decision-making. Database: PostgreSQL (user data). Payments: Stripe. Web analytics: Google Analytics 4. Traffic sources:… Databases & SQL ∙ 8 days 23 hours back ∙ 10 proposals |