What is a multibyte character and how can I identify and remove them from my excel file?

like
Posting as :
works at
You are currently posting as works at

What are you trying to do? Is it just one file, multiple files, will this be a recurring issue? Are you trying to convert it to a different type of file, use it in automated workflow, etc?

Trying to run a population through sampling software and I get an error that the population has multibyte characters, but it doesn’t tell me where in the population they are. I broke up the original population into 12 separate ones, and they all worked fine except this one, so I’m not sure where the issue is.

Have you fixed the issue? I have some thoughts, but don’t want to waste your time if you’ve figured it out.

I was able to get it to work by using =CLEAN on the entire population. Still not sure what happened though.

like

Related Posts

Larsen & Toubro Infotech If don’t have any offer, then you will not get any offer from LTI even though you have cleared all the rounds. Because they will not wait for you for 3 months. Pathetic 😡 Larsen & Toubro Infotech @

like

Can I be part of Microsoft company?
My current role: SQL SERVER Database administrator (Microsoft certified)
I am in a service based company now. YOE:4

Please don't ask me to prepare DSA etc, I am asking w.r.t DBA skills only.

like

I had got bonus on April 2021 as i was retained and it was eligible till April 30th 2022 else i had to return the money in full. So, i left the company on May 2nd 2022. I have now received mail abt recovery. I have to pay them the one time bonus in full. I am now wondering how is this one time bonus calculated. Is it i should put down my papers only after 1 year?! The letter says "You will be eligible for this reward if you remain on the rolls of the organization as on April 30, 2022. "Capgemini

like

If you’re full-time at an agency but looking for additional work as a freelancer, do you say you’re currently working at said agency during an interview for a possible freelance gig? I’ve had an instance where they said they can’t hire someone at another agency due to a conflict of interest. I love my current gig, so going freelance FT isn’t an option. What would you do in a situation like this? Is there a workaround, as it’s typically ghostwriting anyway with zero by-lines?

You don’t need to meet every qualification to apply for a job.

like

Anyone out there living off of (or able to live off of) their dividends? This is my financial goal but I’d like to know if anyone is doing it. What’s your allocation? I have mostly REITs

like
like

Why does IBM suddenly wants people to come over and do in-person onboarding?

like

Need help with 5th grade science question:
Materials that are good carriers of sound are known as what?

Tried google with no luck.

like

Hi Fishes,
I had given interview for network security architect position in Feb last week. And as per recruiter, I got selected for that role. I have been asked to share the documents on March 1st. I did a few followup for the offer letter update and they asked me 2 wait for 2-3 weeks. And now they are saying position has gone on hold after I did another followup.
Could it be because of expected salary ?
Yoe: 9
Exp ctc: 33 (35% on current)

like

thinking about making the move to Havas, I’ve heard they’re making a lot of changes and restructuring. Trying not to base my decision off of all the rumours. Any thoughts from current employees?

like

Looking for your career advice! I currently work as a Content Marketing Manager but would love to move into a Head of Marketing/Marketing Director role. What would be your best tips to make that move? I assume it will take time of course, but I'm wondering what/where I should invest in terms of my training and next career steps. Thanks!

like

Modeling her new outfit!

Post Photo
like

PwC'ers. How much am I looking at for healthcare for myself, my wife, and toddler?

I start in a week, haven't seen figures yet.

Suggestions for dinner in boston?

like

How are your reviews of Nagarro? Is it better compared to Cognizant and TechMahindra? Does it renegotiate if we receive other offer after accepting their offer?

Does Accenture provide a discount to lifetime gyms?

like

63k salary for a HR Coordinator role in nyc … is this fair? I feel like I am just scraping by… and they haven’t started taking out deductions for my 401k/pension yet. Plus side benefits are great and I pay nothing!!

like

I’m drunk at a family party that I don’t want to be at! 🆘

likefunnysmart

Additional Posts in Excel Genius

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Whats a good book/course that will teach me advanced excel skills? I want to be quick with shorcuts etc & learn VBA/Macros. Under $30 please, input is greatly appreciated.

like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

like

Tips on adjusting to Mac? I’ve figured lots of keyboard shortcuts but it’s just not the same 😪

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Anyone use teammates analytics? Does it work well with large worksheet? I am cleaning up this large Excel sheet, it's taking so long I don't even know if it's taking it's time or what.

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

What's the F4 analogy in Office 365?

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

This is pretty vague, but what are some formatting tips n tricks for a model? I know the basics (like color code) but borders, titles, font, tables always look weird and I have no idea how to start

like

Ok, using excel is not a primary function for my role (this will be very obvious shortly...) So please be kind! On my sheet, in the first and third columns, I have lists of reference numbers. In the second column I have a client name. I already identified the duplicates in the first and third columns using conditional formatting.What I need to find now is column 2 value, whenever value in column 3 is identified as duplicate. Problem is, I have over 120k rows of data so I can't filter! Help!

like

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal