Hi I’m doing a copy and paste from my online bank which contains the data I need but when I paste it embedded small icons for each lines and I need to do another copy values only each time...

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

Just paste values directly from the source. Otherwise, a quick way to get rid of those icons is to press Ctrl + G, Special, Objects, Okay. That will select all the icons, at which point you can just press Delete to clear them all out

likehelpful

I would hug you in SFW way if you were in front of me.

likefunny

Related Posts

Citco, how is this company? Any reviews?

like

Does anyone know any hospitals, clinics or private practices hiring administrators or supervisors in NYC? I have my bachelors in health admin & economics, 4 years of experience and 2 years experience in operations and as a supervisor.

like

Had someone lateral into our firm as a fifth year (soon to be sixth). They were kind of a retool and went from small law to the firm I’m at. They are still learning a lot of basic stuff, and I think it’s weird that the firm hired someone at that level as a retool. They sometimes ask me for help with stuff, but I’m just getting annoyed at this point. Can I just say “no” since they’re about to be a mid/senior associate who should know all of this?

like

In this current advertising climate, if I get a freelance gig in pharma, I’ll be extremely grateful. Am I the only one who feels this way?

like

Anyone return to work from maternity leave experience a major change in their role (i.e. getting sidelined or unofficially demoted in their role)? What steps did you take to address this?

like

Best agency to learn strategy at in ny?

like

Student loan debt: original amount, current amount, years out of school, GO (pokemonGo? Got your attention?)

I’m so damn tired of seeing that Creative Director listing at Gongos.

likefunny

Any opportunity for digital marketers

like

I'm considering starting a job at an online charter school but it seems a little sketchy. Anyone else?

like

What is the initial salary of Manager 1 in Business Consulting in EY GDS? Any idea guys?

like

All the fin crime people! How does the day to day work look like and you liking it? Any info on pay and wlb will be appreciated! Please help struggling auditor out

like

Hello Fishes,
My brother is a b.com graduate(2020 passed out) and looking for a job.
The problem here is because Finance jobs requires exceptional skills and academics due to which he is not able to get shortlisted for most job interview screening, he is receiving interview calls from great companies but not able to convert them.
If anybody can help even with an Internship position at their firm that would be a great starter to his career.

PS: leave a like so that I can send Dms across✌

like

Does anyone in pharma believe that creative actually works? Any proof?

like

Quick survey ...

How many of you are acting as Business Affairs Manager, Talent Manager AND Traffic Manager?

Or do you have someone else at your agency doing talent and traffic?

like

Hi! I'm a Content Producer (English and Hindi) with 4.5 years of experience and I am looking for new opportunities. I have been trying for over 2 years with no success. I have experience in the entire process of content production along with knowledge on how to build teams, manage multiple projects, do editorial work and client servicing too. I'm looking for reliable leads and advice on where to apply. If you are not from the same industry, perhaps a friend maybe. Any help is highly appreciated!

like

High(ish) performing staff to senior in transfer pricing. What can I expect in terms of raise?

like

I’ve been hearing that first year tax manager salaries are up to 170 now in HCOL. Is this true?

likefunny

SPHR exam- has anyone ever been “randomly selected” for an application audit? This just happened to me and the sheer amount of effort that is going to go into collecting all the documents almost makes me not want to follow through. Since I didn’t finish undergrad, they’re asking for a copy of my high school diploma or transcript and that itself is going to be an absolute nightmare to get hold of. Guess I’m not really looking for a solution here, just venting.

like

With apologies if this is too shallow a topic… I need advice on the best shape wear. I’m doing a keynote at a high profile conference in a few weeks and haven’t yet shed all the Covid pounds… I don’t care about comfort; I’ll be standing the whole time- I want whatever will hold me in the hardest :-) please help!!

likehelpful

Additional Posts in Excel Genius

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

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

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

like

I want to create a heat map of when people are unavailable with day of week as the columns and hour of day as the rows. I have start times and end times, how can I use this data to create the map?

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Best pdf to excel converter?

like

I need to write a macro that goes into a cell, and essentially appends a "*$A$1" to the existing formula in the cell. Does anyone know how to do this? Currently I end up overwriting the existing cell

like

What's the F4 analogy in Office 365?

like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
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

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

Post Photo
like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

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

how do you index or vlookup when the match isn't exact? like one cell has a comma or space after the value...?

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

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