
Käynnissä
Julkaistu
I need help with XLOOKUP to fetch numerical data from a cell. The cells looks like this: manufacturer=Behr,enable_googlecheckout=Yes,sale_price=6.990000,price_a=3.550000,price_b=3.550000,price_c=3.550000,price_d=3.550000,price_e=3.550000,price_f=3.550000,traffic_light=Yes,amber_level=10,pack_qty=1,is_pack_qty=No,quantity_dropdown=Yes The information contained in the cell can vary. Firstly, I would like to extract the numerical part of the cell "sale_price=6.990000" to a new cell. Secondly, I would like to be able to replace the value (6.990000) in the original cell with another value stored in its own cell.
Projektin tunnus (ID): 40285437
26 ehdotukset
Etäprojekti
Aktiivinen kuukausi sitten
Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
26 freelancerit tarjoavat keskimäärin £40 GBP/tunti tätä projektia

Hi, I can help you create Excel formulas using XLOOKUP and text functions to extract the value from sale_price=6.990000 and place it in a separate cell, then update the original string with a new value from another cell. I’ll provide clear formulas that work even when the cell content varies. Delivery within a few hours.
£15 GBP 2 päivässä
7,5
7,5

Hello, I have reviewed the project requirements and understand that you need assistance with using XLOOKUP to extract numerical data from a cell containing various information. Let's chat and discuss it further. To handle your project, I will start with analyzing the cell data structure and utilizing XLOOKUP to extract the numerical values efficiently. I will then create a formula to replace the extracted value with another value stored in a separate cell, ensuring accuracy and automation in the process. The deliverables of the project include accurate extraction of numerical data from the specified cell and successful replacement with the desired value. Before signing-off my bid, I would like to ask a question, i.e., do you have a preference for the method of storing the replacement values for the cells? Best Regards, Aneesa.
£10 GBP 40 päivässä
6,9
6,9

Hello, With over 7 years of experience in Data Processing, Excel, Excel VBA, Data Visualization, Excel Macros, Statistical Analysis, Statistics, Data Entry, and Data Management, I am well-equipped to assist with your project. I have carefully reviewed your requirements regarding extracting numerical data using XLOOKUP in Excel. To address your needs, I propose utilizing Excel functions such as XLOOKUP and SUBSTITUTE. Firstly, I will use XLOOKUP to fetch the numerical data from the cell "sale_price=6.990000" and transfer it to a new cell. This can be achieved by identifying the position of the numerical value within the text string and extracting it using XLOOKUP. Secondly, I will employ the SUBSTITUTE function to replace the extracted value with another value stored in a separate cell. By referencing the specific text string ("sale_price=6.990000") and the desired replacement value, I will create a formula that dynamically updates the cell content based on the designated value. I would be happy to discuss this project further in chat to ensure a tailored solution that meets your requirements. You can visit my Profile: https://www.freelancer.com/u/HiraMahmood4072 Thank you.
£10 GBP 40 päivässä
6,5
6,5

Hello I can help you create accurate XLOOKUP and formula-based solutions to extract the **sale_price value** from your structured text string and also update or replace that value dynamically from another cell. I will provide clear formulas and a clean setup so the process works even when other parameters in the cell vary. Regards Muhammad
£10 GBP 40 päivässä
5,7
5,7

Having worked extensively with Excel and attained a certification in data analysis, I am confident in my ability to assist you with your XLOOKUP conundrum. I have successfully completed over 50 similar projects which rest assured makes me acquainted with the nitty-gritties of your task at hand. In order to fetch the desired numerical part of the given cell, what we need here is a meticulous parsing technique. With my commendable skills in Data Processing, I can help isolate the sale price for you and transfer it to a new cell without any truncation or data loss. Additionally, I can also devise an automated system using Macros or VBA (that I'm proficient in) to replace any desired value stored in its own cell back into the original cell containing varied information. This way you wouldn’t have to go to each cell individually! My goal as a freelancer is always to create efficient and user-friendly solutions and I strongly believe that my skills make me the best fit for your XLOOKUP needs.
£10 GBP 40 päivässä
5,0
5,0

Greetings, I see that you need assistance with using XLOOKUP to extract and manipulate numerical data from a specific format in your cells. It looks like you want to pull out the "sale_price" value from a string and also replace that value with another number from a different cell. To tackle this, I would first use the XLOOKUP function to locate the "sale_price" entry in the string and extract the numerical part efficiently. Once we have that value, I can create a way to replace it seamlessly with a new value stored in a separate cell. My experience with Excel functions and data manipulation will ensure we handle this task smoothly. I'm confident that I can help you achieve exactly what you need in a straightforward manner. Best regards, Saba Ehsan
£13 GBP 40 päivässä
4,6
4,6

As a highly experienced and accomplished data specialist, I've not only mastered the art of data analysis, data entry, and data processing but have also excelled in utilizing powerful Excel functions such as XLOOKUP to ensure swift and accurate fetching of numerical information - exactly what your project demands. With over 16 years of experience and having earned more than 500 K Euros on Freelancer alone, I can assure you that I'm well-equipped to handle the complexities of your task. Moreover, in an industry that often thrives on outsourcing or working through employees, what sets me apart is my direct involvement in the projects I undertake. As the owner of PVSYS GROUP, a company with a rich 33-year history, you can be assured that the work will be done by me personally. I don't just offer my skills; I offer unwavering availability for my clients. Time zones are never a barrier, as my commitment to service extends to being available round-the-clock for employer convenience. Consider giving this project to me and experience how my expertise and dedication can transform your data entry requirements into an efficient and precise process.
£15 GBP 40 päivässä
3,4
3,4

Hi there. You no need to pay more for this. It is very easy task. I can solve this within a short time. I have worked with many excel advance functions (xlookup, Filter, Text functions). Please contact me immediately. Thank you.
£10 GBP 1 päivässä
2,2
2,2

Here’s a concise, high-conversion proposal under 850 characters following your structure: --- Looks like you need to pull the numerical part of `sale_price=6.990000` from a variable-format cell and replace it with a new value. Worked on automating a Python scrap-to-sheet workflow for an e-commerce client that handled dynamic cell parsing and updates. Approach -> Use Excel formulas or VBA to extract `sale_price` -> Store new value in a helper cell -> Replace original value in the text string -> Test on sample rows. Can deliver in 1–2 days. Happy to walk through a small demo in chat. Quick check: should the replacement preserve the same decimal formatting as the original? --- If you want, I can also draft a **version that uses purely Excel formulas** without VBA—it’s often faster for non-technical users. Do you want me to do that?
£13 GBP 40 päivässä
0,0
0,0

Hello, I'm Vishal Maharaj, a seasoned professional with 20 years of experience in Data Management and Data Visualization. I have carefully reviewed your project requirements regarding the need for an XLOOKUP specialist. To address your needs, I propose to first extract the numerical data from the specified cell "sale_price=6.990000" and transfer it to a new cell. Subsequently, I will develop a solution that allows for the replacement of the extracted value with a new value stored in a separate cell, ensuring seamless data management and manipulation. I am confident in my ability to deliver a tailored solution that meets your specifications. Please initiate a chat to discuss further details. Cheers, Vishal Maharaj
£15 GBP 40 päivässä
0,0
0,0

Greetings, I see you're looking for assistance with using XLOOKUP to extract and manage numerical data from a specific cell format. You want to pull the "sale_price" value and place it in a new cell, as well as replace that value in the original cell with another one from a different location. I can definitely help with this. My approach would involve creating a formula that identifies the "sale_price" within the string and extracts it seamlessly. Additionally, I can set up a method for updating that value based on your requirements. With my experience in Excel and data management, I can ensure this process is efficient and meets your needs. Looking forward to helping you with this task! Best regards, Muhammad Usman Kamran
£13 GBP 7 päivässä
0,0
0,0

Hi, I can deliver what you need. I am a skilled freelancer with 8 years of experience in Data Analysis, Data Processing and I have completed similar projects. Feel free to visit my profile to check latest work and feedback from clients. Connect in chat to discuss details and next steps. Best regards, Bwalya
£13 GBP 40 päivässä
0,0
0,0

You’re looking to extract the numerical value from a complex cell containing multiple key-value pairs, specifically isolating “sale_price=6.990000,” and then update that value within the original cell based on another cell’s input. I understand the data varies in structure, so a flexible, reliable solution is needed for both extraction and replacement. With over 15 years of experience in Excel automation and data processing, I’ve completed 200+ projects involving Excel VBA and macros to manipulate and analyze data efficiently. My expertise aligns well with your need for precise data extraction and dynamic updating within a single cell. I will create a tailored VBA macro that parses the string to find the sale_price value, outputting it to a separate cell, and a function to replace that value dynamically using the new input. This approach ensures accuracy regardless of variations in the cell’s content and can be completed within a few hours. If you’d like, we can go over the specifics to ensure the solution fits your workflow perfectly.
£11 GBP 7 päivässä
0,0
0,0

Hello [ClientFirstName], I hope you’re enjoying a productive day. I’m an Excel expert who loves turning messy cell data into clean, reliable data flows. I’ve worked on projects that parsed delimited strings, extracted numbers, and built robust replacements using formulas and lightweight VBA, no fluff, just accurate results. I’d approach your task by first parsing the sale_price from the string using a reliable split-and-lookup method, then creating a dynamic way to swap that value with a value from another cell. I’ll keep the solution flexible so future rows with the same pattern don’t derail your workflow, and I’ll deliver a compact, well-documented solution you can reuse in minutes. I can handle this now and deliver a tested sheet with clear instructions. Let’s discuss your exact data layout and target cell references, and I’ll propose a tight timeline. Best regards, Billy Bryan
£14 GBP 15 päivässä
0,0
0,0

Hello, I’d be happy to assist with extracting and updating numerical values from your comma-separated product attribute cells in Excel. From your description,I can create a reliable Excel solution that will: • Extract the sale_price value (e.g., 6.990000) from the text string into a separate numeric column • Ensure the formula works even when the order of attributes changes or when additional attributes appear in the cell • Replace or update the sale_price value in the original string using a value from another cell. I will implement this using modern Excel functions such as TEXTAFTER, TEXTBEFORE, XLOOKUP. With my experience in Excel data transformation, data cleaning, and automation, I can also help restructure the dataset into a cleaner format if needed. If you can share a sample file, I can quickly demonstrate the working solution. Best regards.
£13 GBP 40 päivässä
0,0
0,0

Hello, I would be happy to assist you with extracting and managing numerical data from your Excel cells. I have strong experience working with advanced Excel functions including XLOOKUP, formulas, and data extraction from complex text strings. From your requirement, I understand that the cell contains multiple key-value pairs such as "sale_price=6.990000" and you would like to extract the numerical value into a separate cell. I can create a reliable Excel formula or solution that will automatically extract the required number even if the content in the cell varies. Additionally, I can also implement a method to dynamically replace the value (such as 6.990000) with another value stored in a different cell, ensuring the original structure of the text remains intact. My goal is to deliver a clean, efficient, and automated Excel solution so that the process works smoothly for all rows without manual editing. I am available to start immediately and would be happy to review a sample file if needed. Best regards, Arun Kumar
£13 GBP 40 päivässä
0,0
0,0

Hello Sir/Mem I read your project and I can do this data entry work accurately. I have good typing speed. I will complete the work on time. Please give me this opportunity. Thank you.
£700 GBP 15 päivässä
0,0
0,0

Northampton, United Kingdom
Maksutapa vahvistettu
Liittynyt maalisk. 8, 2026
$30-250 USD
$250-750 USD
₹600-1500 INR
$250-750 USD
₹1500-12500 INR
₹1500-12500 INR
$250-750 USD
₹37500-75000 INR
€12-18 EUR/ tunnissa
$8-15 USD/ tunnissa
$8-15 USD/ tunnissa
₹12500-37500 INR
£20-250 GBP
₹1500-12500 INR
$10-30 USD
$250-750 USD
₹1500-12500 INR
£18-36 GBP/ tunnissa
$250-750 AUD
₹1500-12500 INR