Hello Everyone,
How do I capitalize the three letters in parentheses, as per below picture?
I appreciate your help!

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

You can also do a find & replace - highlight that column, ctrl+f, replace, (Aer) with (AER), click match case/exact match or whatever and voila

likeupliftingsmarthelpful

This is the way. It must be stressed that it's very important to include the parentheses () in this case , as you suggested, or it will capitalize all instances of Aer. For example, if they had "Maersk" somewhere in the cells, it would turn to MAERsk.

like

Here it is 🙂

Post Photo
likehelpful

Thank you!

like

=len(right(5))and then do upper formula for those cells and then a concatenate

likehelpful

Thank you!

like

Great teamwork!

like

Thank you so very much!

like

For each column?

Yes

The suggestions provided work although may not be computationally efficient. Whether it is or isn’t depends on your dataset. If you have a lot of columns with text at the end that you want to set to uppercase then M1’s suggestion works well. If you have a smaller data set and/or do not have a lot of variation in the parenthetical text then D1’s suggestion may have a quicker implementation.

Thank you!

Lol i just finished a project on classifying new Equipment names into their types. Unrelated to excel: using excel to tag the names each time for 100s of rows was painful for my firm, so i usee python deep learning to classify them. Might wanna try it. Saves hours in a week. 100/100 recommend.

Related Posts

Has reaching out to someone within a company you want to work for ever worked in your favor? I want to be noticed, but not pestering, and am unsure if it would hurt my chances.

like

Anyone switch from middle market to big 4 and regret it?

like

How is the career of software engineers after 40? Do they find it difficult to get jobs ? What kind of roles can they do ?

like

Could you seriously date someone who isn't on the same financial level as you?

like

Does anyone work at or familiar with the Blackbaud Inc. I’m interested in hearing more about peoples experiences with the company?

like
like

Hello Guys ,
I am looking for a refer in paypal for the role of data scientist 1 .

I have an exp of 5 years. Can someone please refer me to this role .

I am currently in sales and I hate it. Does anybody know of any good career paths I could pivot to that I could make a decent salary that is not sales?

likefunny

What is the increment cycle in tiger analytics?

Ladies, what would you like as a graduation gift in $300-$500 range that is not a handbag or a cellphone.

like

Do I have to learn software in order to continue being an engineer? Every time I do a job search for "Mechanical Engineer" - software, IT systems engineering positions pop up.

like

How much hike one should expect in their first job change after 18+ months of experience?

like

I want to evaluate my standing in terms of pay and how am i doing relatively..Any opinion would be hugely appreciated. I am 29 m, married, senior Consultant making 105K$ base in Dallas with 6 YoE

like

God forbid if you plan to even warm your pre cooked food 😓😓

Post Photo
likefunny

Hi All,
I'm looking for Management Consulting or Project/Product management roles. Currently serving notice period and available to join in 10 days.
YOE:4.5 Years(B.E.+MBA-IIM Raipur)

Please let me know in case of any opportunities in your organisation.

like

Something to brighten your day 🤗
May Allah bless you all with ease, happiness, great health, and success ameen! Wishing you all the best 🫶🏻

Post Photo
likeuplifting

Experienced Data Privacy & Cybersecurity consultants being recruited for in our NYC office. Good WLB and hybrid work offered. DM to discuss potential referral 💪

like

Queridos creativos hispanos, por favor todos los días sin y con cuarentena veo que trabajamos duro y hacemos las cosas bien hechas (a veces hacemos más de lo que nos piden) y a la nuestros compañeros les gusta ynos siguen usando. Está bien que nuestro trabajo sea reconocido pero por favor no sean tímidos en decir que necesitamos un salario decente tan cuál como todos los demás que más bien hacen menos y todavía les pagan. Hay que insistir no solo para el individuo pero para ayudarnos a todos!

like

Additional Posts in Excel Genius

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

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

[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

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

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

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

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

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

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

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

Post Photo
funnylike

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

What's the F4 analogy in Office 365?

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

What are the most typical models you all build

likehelpful

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

like

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

Post Photo
like

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

like

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

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

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