Đã hoàn thành

Excel Text to Column separated by comma

I have an excel with 1033 rows, i need to do text to column using comma "," as separator but not the commas inside the ' '.

Example:

Product,'Metered Rack PDU,120V Output,208V,3PH Input'=>'PDR-AP7862'

Expected Result:

Product | 'Metered Rack PDU,120V Output,208V,3PH Input'=>'PDR-AP7862'

Example 2:

Type,'6AWG,1,000FT Spool,White'=>'SPSILA-006G-WT'

Expected Result 2:

Type | '6AWG,1,000FT Spool,White'=>'SPSILA-006G-WT'

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu

Xem nhiều hơn: number separated comma excel, add comma instead space excel, create list number separated comma excel, excel dont format automatically comma separated data, add separated comma excel, excel numbers period instead comma, excel combining sets numbers comma, excel format number india comma system, using numbers text giving commas excel, excel sheetwith macros automatically adjusts security level excel, write data text file separated delimiters vbnet 2005, adding comma list numbers excel, display employee number salary salary increase rounded numberlabel column salaryadd column subtract salary salarylabel column i, excel vba combine multiple columns single column, i banking excel outsourcing, urgent requirement i am looking for a freelancer who can enter data to excel sheet from images that i will provide with excellen, urgent requirement!! i am looking for a freelancer who can enter data to excel sheet from images that i will provide with excell, where can i hire excel expert, can i get excel support, how do i find excel expert in sri lanka

Về Bên Thuê:
( 49 nhận xét ) Miami, United States

ID dự án: #20163650

Được trao cho:

uhjk

Hello, I can do it in <1 hour by creating php script. It seems project description is clear, let me know. Thanks.

$20 USD trong 1 ngày
(65 Đánh Giá)
6.0

51 freelancer đang chào giá trung bình $19 cho công việc này

Motiurlaw

Okay understood. I will split them into column accordingly. Message me so I can do some sample right now for you. Thanks

$35 USD trong 2 ngày
(263 Nhận xét)
7.1
prameswara

Hello Sir im excel VBA macro and formula Expert :) i can do make tools text to column separate by comma please ping me now and im able to start working right now THank you Galih

$30 USD trong 1 ngày
(371 Nhận xét)
7.2
imperturbable54

Hope you are having a great day! I am interested in this project and would like to offer my help. I have done such tasks in the past and will be successfully rplace the commas with pipes If you check my Portfolio I Thêm

$20 USD trong 1 ngày
(170 Nhận xét)
6.7
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$30 USD trong 1 ngày
(108 Nhận xét)
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom f Thêm

$25 USD trong 1 ngày
(90 Nhận xét)
6.7
ESOLUTIONSSS

Hello Sir/Madam, It is my pleasure to be able to bid on your project. Right now i will start working on your project. Really very much interested to have this project, if you permit. Please check my reviews for bet Thêm

$10 USD trong 1 ngày
(86 Nhận xét)
6.5
rinabuoy13

Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$20 USD trong 1 ngày
(89 Nhận xét)
6.0
TechnoGuruu

Hi, As per requirements I will separate the columns based on commas outside quotation symbols as per description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality Thêm

$30 USD trong 2 ngày
(79 Nhận xét)
5.9
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$30 USD trong 1 ngày
(108 Nhận xét)
5.8
MdJahangir1

Dear Sir, I am ready to start your jobs right now.I have done same project many times.I can complete this job in short [login to view URL] please give me a chance to work for you. Thanks, jahangir Hossain

$11 USD trong 1 ngày
(131 Nhận xét)
6.0
valor312

VERY EASY FOR ME Hi, Nice to meet you. I can do it within 30 min When it comes to Excel, I am an expert Please see product I made recently using VBA and C#, python, java, excel management https://www.freelancer.com/pr Thêm

$30 USD trong 1 ngày
(34 Nhận xét)
5.4
rashaw

Hi, I have 10 years knowledge in advanced excel and I can do this job as the result expected. Text to Column function with custom logical based function is the solution for this task. Ram

$20 USD trong 1 ngày
(52 Nhận xét)
5.1
sangwanpankajs

hello sir i can do this work in few hours from now....i have checked your file i am an expert in excel and have done many excel projects in past with excellent reviews and ratings so far so please msg me to discuss Thêm

$18 USD trong 1 ngày
(80 Nhận xét)
5.3
marefin34

Hi there, I am able to separate the file by comma as you have shown in the description. I will do it without any error. Just like to get hired to start asap. Best regards, Mahfuz

$30 USD trong 1 ngày
(65 Nhận xét)
5.1
SidhuDN

Dear Sir/Ma'am, I am ready to Excel Text to Column separated by comma. If you want, then I am able to start your work right now and give you the task within 1 hour. Without wasting your time I want to make a sample, Thêm

$25 USD trong 1 ngày
(23 Nhận xét)
5.2
dataentry4expert

Hi I read your job description and understand that I am perfect for this job. I am Expert in Advance Excel like Power Query. If you hire me, I can complete your job very carefully and satisfy you with my work. Regar Thêm

$10 USD trong 1 ngày
(32 Nhận xét)
4.4
umairabdillah12

Hi sir, I can finish this job in just 30 minutes, please give me this project, I will prove it, i will send you sample before we have a deal. thanks regards

$10 USD trong 1 ngày
(5 Nhận xét)
4.3
franchise63

I'll do it for 6 dollars. If your file is aligned properly I can finish the job in 1 to 2 hours. Hit me up if you're okay with that. Thank you Francis

$10 USD trong 1 ngày
(1 Nhận xét)
3.8
Monirulop

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly commu Thêm

$10 USD trong 1 ngày
(9 Nhận xét)
3.4
writingapp

Hi. Simple project. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile

$15 USD trong 1 ngày
(5 Nhận xét)
3.5