Anyone know a macro for the Trim function.. applied to the whole sheet or Relative Reference is fine too ?

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

You can do a loop in VBA and use the trim function for each cell and override the data
Sub test()
Some this like for i = 2 to 1000

Range("a" & i) . Value = Application.woorksheetfunction.trim(Range ("a" & i).value )

Next i

End sub

like

Related Posts

What's the difference between Partner, Principal, MD and Specialist Leader within Deloitte consulting?

like

Hey Fishes. I have a dependent L2 American Visa which probably will land to Texas. Do you guys think there's good opportunity for SDET roles. I have around 6 years of experience. Need to know whether coming 2 3 months is good enough to relocate or shud I wait until next year. Additionally do you guys think is it possible to fetch jobs from here for person having L2 Visa ?

like

Hello Team,

Is it possible to check the status of the application in cognizant? I was applied directly in the career portal. Thanks

like

I work remotely and live in a low-cost area. I didn't even notice inflation.

like

How do you overcome humility at job interviews?
I haven’t been at the market for 8 years, and I am struggling with bragging a lot. I don’t even know where it comes from but I downplay my achievements a lot. I practice Buddhism and bragging is not the best trait for a Buddhist for sure. But downplaying is not a Buddhist trait too.
So I guess the question here is how to reframe bragging into something more acceptable...

like

Is a referral needed for the Facebook RPM position? Im sure they get a ton of applications so wondering if there’s even a chance just applying outright

like

Do cops get any support for their mental health?

like

Favorite science show to watch as kid?

like

Hi Fishes,

How many weeks will the BGV take at Allstate. Since i was an immediate joiner, BGV started after joining.

Thanks

like

Currently in a finance role looking to break in PE or VC finding it a little difficult as I’m applying to analyst roles and keep getting rejections. Any advice ? Or referrals?

like

Has anyone done GT Reskilling Program?
Any tips? Or what is the general interview process and how competitive is it?

like

Hi,
I am having 6 years of experience as an accounts receivable specialist working in US mortgage loan with dispute resolution skill as well.
Looking for a better opportunity.

like

Being a realtor is not what I expected! I was so excited when I joined being younger, but nowadays it's all work and too little time off. It's a bit frustrating because I'm not sure where to go from here. I've been doing this for 5 years now. Any help on what choice to make? I do not have a backup plan.

like

Thoughts on robo-advisor accounts? The ones that take your spare change of every purchase and round it up? Betterment, Acorn. I have to imagine it’ll take quite some time for $$ to accumulate that way?

like

CS masters background from top US university, working as DS (probably promote to SDS in 3 mths) in MBB analytics. Have a VC firm venture partner reach out due to CS background and prior... cont’d

What does everyone do for CharlieCard fees when there's the possibility that you'll be traveling at a moment's notice? Weekly/monthly pass or just pay by trip?

Any strategy suggestions to show that brand awareness for organic social is just as important to drive sales?

Client needs to see value only through $$$$$$ and we’re working with a 🦕 website with absolutely zero budgeting. 😭

like

XLM - great opportunity to buy now. Get in and thank me later!

like

Best east village restaurants?

like

Additional Posts in Excel Genius

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

like

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

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

[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

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

Post Photo
funnylike

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

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

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

like

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

likeuplifting

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

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

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

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

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

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

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

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

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

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