I’m trying to extract numbers from a string. I googled a formula, however the formula rounds up the last two digits of a 16 character string. Is there are a formula I could use eithoutcharacter limit?

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

Without a character limit *

Try text to column feature to break up the column if there is a limit to the number of characters the data can pull from.

Select column, hit alt, a, e

Then fixed length And then arbitrarily break the column into two

You can do the formula left or right it pulls a certain number of digits from the left or the right as indicated

I would try it but if it doesn’t work try text to columns

Related Posts

I’m a healthcare recruiter that specializes in physician and CRNA recruitment across multiple specialties. I’m curious from the other side of the same nickel, what do you want in a new job? Are you interested in travel contract work?

like

At what point do you elevate your peer’s mistakes to managers? It feels like my teammates elevate each other frequently but I don’t like to get involved because it seems like tattling. Do managers value knowing who on their team is messing up in small ways?

like

I think tools like BP and UiPath will be irrelevant in a few years. They deliver nowhere near the value that consulting firms declare imo.

likehelpful

Can anyone refer me ?
Tech Agile Consultant (Scrum/Kanban/SAFe)
YOE - 9 years

like

Does anyone have the new Nike pegasus 39? What do you think about it? And if you have previous pegasus models, how does it compare?

like

Hi,

Is it fine to call a HR if he's not answering. I have my HR discussions pending.

I called him once a day (twice on 2nd day with a gap of 4-5hrs in between)
for two days straight and third day he picked my call for scheduling the final interview.

It's been a week & he told I would receive a call from his team before today, but didn't receive.

Can I call him to remind or just keep on waiting till I receive a call from them.

Getting a reply for mail is highly unlikely. Please suggest

like

I so badly wanted to get offer letter and resign from my company.

Now I have OL and serving notice, still I’m not happy and want to go for higher package and better offer.

Seems like, This is a never ending rat race, what do you guys do to relax? To have some quality time? I am somehow not able to enjoy my life and this hits me hard quite often.

Also it’s easy to see people earning double with same YOE. Do you guys feel the same?

like

Recruiter here: Antitrust is very hot right now and I just got another great opportunity. DM me if interested.

like

Need 11 likes for the DM feature. Do show some love fellow fishes :)

like

Searching for Abinitio Support roles. Current technical support lead in TCS with total 6.10yrs exp. Relevant experience 4+. Pls share opportunities.

like

New to Fishbowl! How do folks find this app most useful?

like

Is it possible to switch from PM/program management to strategy? Any advice?

like

Anyone with full VA healthcare; did you decline your company’s heath care plan? I’m in Washington DC and question the quality of the VA healthcare

like
like

Are we allowed to be as obvious as possible during interviews on what clients we worked on so long as we don’t say their name? Ex: one of my clients went through a huge merger in x industry in my city, and if I were to state that in interviews it would be a dead give away. Is that okay?

like

How’s the Liberty Hill ISD? Looking at a few houses in Leander but uncertain about being assigned LH schools

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

Where do V20 associates commonly exit to when going in-house?

like

I have this offer from Wipro. Can anyone help me with in hand salary.
What exactly is Wipro benifits paln? Will that amount be added in my monthly salary?

Post Photo
like

Additional Posts in Excel Genius

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

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

like

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

Post Photo
funnylike

Need some help. Is there a fax function (Filter) so that if I want my subtotals to show a number but nothing below it to report. One expansion of a row the subtotals show but no numbers below it.

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

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

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 :(

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

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

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

Hey, tips for where to look for good excel cheat sheets online? :)

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

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

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

What are the most typical models you all build

likehelpful

What are your top Excel ninja tricks? Ones that few people know...

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

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

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