recommendations for using RegEx or RegEx-like features to find/replace confidential information (SSN, tel numbers, emails, names [no specific format]) *without* using a VBA macro?
I’ve gone through all of the obvious workarounds (e.g., I can use the *(at)*.com syntax for email addresses and (???) ???-???? for tel numbers that are formatted as such in my data), but need something a bit more formulaic.
If macro/add-in is my only solution, any recommendations for something that is open-source? thx

Who is bipolar and/or has major depression and/or has anxiety and/or is/has anything else? Who has been in a mental hospital? Who has been to rehab? Who sees a therapist? Who sees a psychiatrist? ...

Anyone hiring for Workday HCM AMS ?

If we join at P4, how much experience is required to get promoted to P5 ??

Hi. So I'm about to begin employment with United HealthGroup. It will be for Medicare recipients. I have some years experience with Medicaid. Any advice? I know, at first, it'll be working on the phones. Any thoughts also on how to get off the phones or how to move into other positions? Thank you.

Anyone here took the USI localization program?

Looking for opportunities as a data engineer with 2 years of experience .lwd 28th aug .
@expert in azure and sql
Have been trained in bigdata technology.
Any help would be great!

My practice got super busy after the pandemic. I have had a waitlist and been incredibly busy. It’s been stressful, but I have been grateful for business & to be helping people through a crazy time. This fall, I’ve noticed things slowing down and I don’t really know why. Has anyone else seen any similar trends (or know what might be going on)? TIA.

How do you handle people who deny climate change and global warming? It happens way more than I'd like it to when I tell people what I do for a living. I used to ignore it, but I want to start clapping back at them.

My brother-in-law (age 30) told us recently that he is transgender. How can we support him? (‘Him’ as we haven’t discussed pronouns yet). It was a surprise to us!

People who absolutely HAVE to live in Manhattan amuse me lol

Was lowballed and don’t want to play catch up for the rest of my life. What is the best timing & ways to ask for a raise? Or should I exit to correct my mistake. Happy to dm with my specific info

Guys !!
How much should I get as a DevOps Engineer with 1 yoe?

Hi Fishes,

How is culture at Hexaware ? Especially there Central Bid Management or RFP team?

How many annual leave days do you get? (I’m in the UK and a company i’m considering offers 25 days off a year)

Hello, I am currently having 6 years of experience in US Taxation in Partnership(1065) Federal. Currently I am in the position of Assistant manager, I have cracked the interview of a few Big 4 companies.
Whats the Fixed CTC should I ask for?

Start as a copywriter - learn the briefs -- the why behind the what -- and you'll make an easy switch to strategy

Anyone from accenture capability network in sap s4? Please dm or comment. I have some doubts

What’s a reasonable amount of OG questions to do per day?

how long it takes to start with project in global logic?

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.

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

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?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

How do I compare two sheets to make sure they are identical?

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?

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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)

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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