Completed

In csv excel represent one column value wrong way. I need correct format

I have attached one sample csv file. Look for coloumn category_ids. It shows value like this "404,640,944,367"

while actually it should show "4046,4094,4367". This column represent category id which is 4 digit value. for any product it may be one category id or more than one also possible. here 3 category_ids assigned

I tried many different way to format it but no luck. It works perfect in open office but i need solution in ms excel.

Does anyone has solution for this? If any one has solution they can submit screenshot of working and i will award project to only him. This is very small task for excel expert.

regards,

sunny

Skills: Excel

See more: mysql import csv excel, vba excel delete column, macro convert csv excel, why does my exported csv data get converted to weird formats?, how to keep text format in csv, how do i keep a long number format on a csv file?, csv file loses formatting, how to keep number format in csv file, open csv file in excel without formatting, how to force excel to open csv files with data arranged in columns, csv files lose formatting after save, search data csv excel vba, howto export data csv excel format php mysql, excel convert column rows, csv excel automatically, excel convert column multiple columns, excel vba increment value, microsoft excel column value formula column, excel macro cut paste based column value, excel assign rank value based column values

About the Employer:
( 11 reviews ) Ahmedabad, India

Project ID: #19656068

Awarded to:

nvchien94

Hello there, I am an Excel expert. Please contact me I will support you. Just some trick in excel. Thank you.

$15 USD in 7 days
(84 Reviews)
5.3
vwantmoney1

Hello Sunny, I have solved your problem. Kindly contact me via chat so that I can provide you the screenshot for the sample I have completed. Thank you, Kind Regards, Snigdha Paul

$10 USD in 1 day
(37 Reviews)
5.5

20 freelancers are bidding on average $21 for this job

c4cuteconain

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the skills and knowledge required for this project. Please send me a message and we can discuss further.

$20 USD in 1 day
(46 Reviews)
5.4
Imranatmoon

Hi Sunny, I got the solution please reply to this message for a screenshot (sorry can't upload with you replying.) Imran

$30 USD in 1 day
(39 Reviews)
4.6
paulodayto08

Hi Good Day! A serious freelancer here. I've done a lot of job like this before and I can help you with this project. Please consider my bid. I already checked your file and trying to do a solution using formula. More

$20 USD in 1 day
(24 Reviews)
3.7
srijanagrawal21

Hello, Hope you are doing well. I can help you in your project About me & what I can provide - • 5+ Yrs. of Experience in EXCEL & VBA. • Knowledge of DASHBOARDS, FORMATTING, PIVOT, SLICER, GRAPHS, CHART & FORMULAS. • More

$25 USD in 7 days
(21 Reviews)
3.8
bktk

Hi Dear Sir, after reading the project description, Sir I am able to write proposal for this project. Sir I am expert in all those skills which is mentioned here, and all those which is require for this project. Sir I More

$10 USD in 1 day
(35 Reviews)
3.7
abhaymshr091

I have read the job details and screenshot is ready and you can contact me anytime via chat. And You can send me the full file.

$15 USD in 1 day
(15 Reviews)
3.3
frozzenmatteo

HI! I think, I have found the solution for your problems, please chat and i'll show you the screenshot

$15 USD in 0 days
(6 Reviews)
2.9
hassan115781

Dear Hiring Manager! I have reviewed your requirements for your preconceived project. I'm interested in your project. I have 3 Years experience in Data Entry, Data scraping, Lead generation & Web research. I'm availa More

$20 USD in 3 days
(3 Reviews)
1.8
rashidm1982

Hello there, After carefully reviewing the requirements of the Project, I believe that my strong experience and dedication make me a suitable match for this. I have vast experience in Excel Data Entry with more than 1 More

$20 USD in 2 days
(2 Reviews)
1.4
mohakagarwal67

I am very good at arranging the data in a organised format in excel. I know many formulas and the shortcuts that help me to get it done in minutes or a few hours depending on the type of work

$15 USD in 1 day
(0 Reviews)
0.0
RachitGroup

Hello Dear Client, I read through the job details of your project and I am absolutely sure that I can do this project very well, I have more than 5 years of experience in it. I Provide - - 24x7 Services to My Cl More

$30 USD in 1 day
(1 Review)
0.0
kimiachie

I can do this since I have so much spare time

$25 USD in 1 day
(0 Reviews)
0.0
mudassarbhinder2

Hi! Hope you are fine. It's Mudassar here. You can trust me i'll deliver 100% accuracy. Can you give me a chance to serve you? Kindly consider me. Best wishes, Mudassar Relevant Skills and Experience I am well in More

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
aan5856830715bf4

Hello, I am ari, I've carefully gone through your project brief and I confidence that I have the expertise to work on your project. I will be very happy to have a chance for an interview with you.I'm always commi More

$25 USD in 1 day
(0 Reviews)
0.0
hammadbawany89

i have done it already in excel. dont know how to attach file i will do it for you in 5 mins just let me know when to start

$15 USD in 1 day
(0 Reviews)
0.0
sathishtr

I will resolve the issue and will provide you the exact in ms excel format

$25 USD in 1 day
(0 Reviews)
0.0
sashmita2712

data entry I am Data Entry Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy . If you are looking for data entry or search work, I am th More

$30 USD in 2 days
(0 Reviews)
0.0