What's the easiest way to remove all text from number ?

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

You loop through the cell and pull numerical characters:

Like this - there are always edge cases (e.g., what if the input cell contains “23%” - should it out “23” or “0.23”), but this is the basic idea

Post Photo

Use substitute formula to remove them.

Related Posts

like

I have recently joined Wipro, in my offer letter my location is mentioned as Gurgaon and in PSP page under Project Allocation location is mentioned as Banglore, so what is my base location ?

like

Any paralegals used Upwork or similar sites for side work/freelance work? Just wondering if it's worth the time investment. All feedback is appreciated!

like

I have an interview coming up for a Case Manager position for the in-home care company. I would have 16 patients in my caseload 9 locally & 6 out of town. The company said the case managers are the backbone to their organization. Is the workload much greater than the in home nurse? Would a Case Managers make more an hour bc of their leadership decisions & caseload they are responsible for? In Indeed the ranges for salary varied. What would you negotiate for in NW Ohio area?

likehelpful

Capgemini and Capgemini Engineering work location are same in Noida?

like

What will be the work from home benefit’s in IQVIA?

Hi Folks,
EY GDS is hiring for multiple roles spanned across Data Visualization, Data Engineering, Digital, Data Science, QA, RPA, UI. DM me for complete Job Description and Referral for a suitable opening.

Post Photo
likehelpful

Give suggestions on companies to apply in Bangalore.
Want a transition from Data Engineer to ml engineer/data scientist.
Yoe - 1
Engineering- tier 1 nit
Skills:
AWS Associate solution architect.
Azure agile working environment.
Python, sql,Hadoop, spark big data, ci/cd pipeline, aws cloud computing
Regression, pca, knn, ensembles , decision tree etc
Currently working in pharma industry.
Please provide refrell if you have any.

like

Any experiences with coworking office spaces in Vancouver? Looking for an office space for 1 day per week around the downtown area.

Any tips on how to improve lining thickness? My RE had me on Estrace for a week before starting Prometrium (vaginally) a few days ago, but my lining is only a little above 5mm. Looks likely that this FET cycle is going to get canceled (was potentially going to be this weekend) since the lining doesn’t seem to be thick enough. This will be the 3rd transfer cycle that’s getting canceled, it just really sucks...what’s worse is I didn’t see my doctor today, just the sono tech, (cont’d)

like

What’s the furthest you’d drive for fertility treatments? I had to do clomid iui with my daughter and trying for number 2 but the office isn’t accepting new patients at this time

like

No one is talking in this grp. Why?

can any explain the advantages/disadvantages of doing a lump sum pension payout rather than waiting till retirement? I no longer work for the company so does my pension not grow so getting lump sum is better to move to an IRA? thanks in advance!

Hi Everyone, our organization is looking to add an experienced account leader to our team. Through the vehicle of a digital marketing & analytics agency, our mission is twofold and ordered: 1) to empower our team to achieve their dreams and to best help others; 2) to honestly partner with our clients, and with their best interests, build scalable solutions that provide profitable growth.

like

How do you fix microsoft excel cannot paste data error?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Looking for a job in GSK , as a technical Argus safety pharmacovigilance consultant with 9 years of experience. Thanks in advance .

like

Have you been party to a great training sessions on PLG - product led growth? If so what made it great for you, your team, your leaders etc.

like

Great idea! 👏

like

Those in Orange County, senior or manager. Anyone interested in Capital group? They are in Irvine and hiring.

like

Additional Posts in Excel Genius

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Still don't have xlookup. #fomo

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Would anyone be willing to teach me vlookup?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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

Scan your QR code to download
Fishbowl app on your mobile

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