Find Jobs
Hire Freelancers

i need an excel expert to solve a problem.

€6-12 EUR / hour

Closed
Posted about 4 years ago

€6-12 EUR / hour

im working in a office, so i want to mask some data with asterisks (numbers or text) to the next column, like this: 13067601701 -> ****7601701 but i cant find the way or formula or whatever is this. i serach to the internet but cant find the way to work in my excel.
Project ID: 23952855

About the project

33 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
33 freelancers are bidding on average €9 EUR/hour for this job
User Avatar
Greetings! It is pretty straightforward - please try the formula "REPLACE(A1,1,4,"****")" and let me know your feedback. Have a Great Week Ahead! Srinivasan
€10 EUR in 1 day
5.0 (228 reviews)
7.1
7.1
User Avatar
Hi, I can create the formula to hide first 4 letters and display asterisk for them in few minutes. I am ready to provide the solution right now....just waiting for your reply. Regards
€8 EUR in 1 day
5.0 (213 reviews)
6.7
6.7
User Avatar
<<<SOLVED>>> I can send you draft right now. Hello sir, Good day. I have read your project description and review your attachement carefully and i know the solution of masking your data absolutely as you want. Please message me to discuss more. Thanks.
€6 EUR in 40 days
5.0 (249 reviews)
6.3
6.3
User Avatar
I am a professional with all the skills and knowledge required for your project. Please review my profile as I am a preffered freelancer with excellent employer feedback and Satisfaction rate. Please send me a message and we can discuss further to start working on the project.
€6 EUR in 40 days
4.9 (114 reviews)
6.2
6.2
User Avatar
I am full time freelancer with postgraduate having more than 6 years of experience in advanced excel based tools, VBA automation, dynamic dashboards, web application, web dashboards, google spreadsheets, google scripting, financial modeling, and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed excel based automation tools for Ernst & Young also. You can get your work done here with highest quality at lowest price. No payment required in advance, please pay me once the job is 100% complete. . Please initiate a chat so we can discuss on this as I may have some questions.
€20 EUR in 40 days
4.9 (47 reviews)
5.8
5.8
User Avatar
Hi, I can do it by using excel vba program (macro). I am experienced Data Analyst and Macro Developer and have done many similar jobs. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
€10 EUR in 40 days
4.8 (115 reviews)
6.0
6.0
User Avatar
Dear Sir, I’m Javed. My computer experience is 12 year's more. I’m expert on Microsoft Advance Excel, Mask Text or Number ****760, VLOOKUP, Consolidate/Combine Multiple Excel, Pivot Table, VBA, Macro, 200+ XLS Formula, Flow Chart, Subnet Calculation, Automated Attendance and Microsoft Excel related any administration tasks. Can you knock me in the chat list so that we can discuss more about this project? I hope to hear from you soon! Kindest regards, Aquib Javed
€6 EUR in 40 days
4.7 (54 reviews)
5.4
5.4
User Avatar
Hi there, I can make the formula you want. Can you say how many asterix you want or how many characters on the left you want to hide? Regards Reuben
€6 EUR in 10 days
5.0 (20 reviews)
5.0
5.0
User Avatar
Hello Client, I have gone thru with the attached data file and your requirements. I would like to take this up. request you to please provide your consent for kick--off this project. Thanks, Jitender Kumar
€9 EUR in 40 days
5.0 (17 reviews)
4.6
4.6
User Avatar
Hi there! Seems like a small problem I can help you save some money on. Drop me a message to share with me more details I am usually available from 8 AM to 11 PM (GMT+8) and will reply within an hour. Cheers!
€6 EUR in 40 days
5.0 (13 reviews)
4.3
4.3
User Avatar
Hi there, Yes! Let me do it so simply using Python. Will deliver portable CLi app for your job. Great exp in data processing including regex. Wish to be hired. Serious bidder. Best regards, Ishaq
€7 EUR in 10 days
5.0 (20 reviews)
4.4
4.4
User Avatar
Hi there! masking can be done using simple formula. I am Bhakti from India. I am interested to work on your project. I would like to get contacted and get more details on this project. Hope you will contact me. Thank you :)
€6 EUR in 1 day
5.0 (11 reviews)
4.0
4.0
User Avatar
I have 5 years of experience working as a financial analyst, dealing with VBA macros on a daily basis. Please contact me for more details. Thank you!
€12 EUR in 30 days
5.0 (11 reviews)
4.2
4.2
User Avatar
Hello, I would like to help you with your project, I have a lot of experience in Excel and VBA macros. I have a Master in Applied Computing. I have more than 10 years of experience in programming in several languages and data analysis. Great experience in data mining. Applied Mathematics, Statistics and Large Data.
€6 EUR in 40 days
5.0 (13 reviews)
3.6
3.6
User Avatar
Excel expert here, ready to fix this for you right away. This will be an easy formula using a new column with left()/right()) or formatting with format cells 000,,"-**-****" Depends on your preference.
€20 EUR in 20 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Greetings, Throughout my 35+ years career IT and Service industry, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Please refer to portfolio "Excel Pivots and Charts". I can help you right away. I have the expertise in Excel and I have been training people on Advanced Excel. I have normalized/cleaned up lot of data, collected from various sources and made it easily usable. Provided numerous solutions using Excel in the area of Budgets, Actual, Revenue Projection, Gross margins, Project Estimates / Plan / Monitoring / Reporting, Performance Assessments etc. These required me to use lot of functions & formulas and very innovative Pivot table features. Keen to take up this assignment as I love working with Excel. If proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards
€9 EUR in 31 days
5.0 (2 reviews)
2.5
2.5
User Avatar
Hello there, As a Data Scientist I have huge experience working with several tools / techniques like: - Web Scraping - Python Programming - Vba Code (Macros, Graphs and Dashboards) - Machine Learning (Models, Data Analysis, Preprocessing and so on) - C++ - NLP I am sure I can help you with your project, let me know if you want me to work with you and send me a message! Greetings!
€6 EUR in 5 days
4.2 (2 reviews)
2.2
2.2
User Avatar
I'm currently doing a similar job of data entry and also meticulous worker in terms of accuracy. Let me do the work for you. Thanks.
€8 EUR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Easy as Pie. I have extensive experience in this field, having completed a number of similar projects in the past. Working with me will not only be cost-effective and time-efficient for you, but I guarantee that the specialised services provided are compliant to the highest levels of international quality and standards.
€6 EUR in 62 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am excel expert I know the formulas to be used to split data or join data. Please give me a chance.
€10 EUR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GREECE
Pátrai, Greece
0.0
0
Member since Feb 17, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.