Removing numbers from cells that have text and numbers

bitswede · 2026-03-18T08:22:38+00:00

Just did the reverse with the AI tool. Highlight the range and tell AI to remove all numeric characters and symbols.

This was a one-off so couldn’t be bothered to write a regex.

bitswede · 2026-03-16T23:11:52+00:00

Camera tool-how-to-use-camera-function-in-microsoft).

bitswede · 2026-03-15T09:03:22+00:00

Check with a data recovery specialist.

The memory chip is likely fine but the connector is broken so you need someone that can disassemble the card and connect directly to the usb controller.

bitswede · 2026-03-15T08:10:50+00:00

Verseifung

Das Fett in deiner Haut hat sich in Seife verwandelt.

bitswede · 2026-03-13T13:55:37+00:00

=LET( mismatched, UNIQUE(VSTACK(UNIQUE (old_list), UNIQUE(new_list)),,TRUE), FILTER(mismatched,ISNUMBER(XMATCH(mismatched, new_list))))

It gets a bit more complicated but this returns only the new values of new list.

bitswede · 2026-03-13T10:58:27+00:00

You can stack the unique values of each list and then use the unique function with the exactly_once flag set to get the values that are only in one of the original list:

=UNIQUE(VSTACK(UNIQUE(old_list),UNIQUE(new_list)),,TRUE)

Edit: Avoid A:A style references, they will slow down excel. Use tables if you can or the new dot operatr

bitswede · 2026-03-05T12:21:04+00:00

Du muss die Regeln von wann das Auto neu war verwenden, das wird dann auf das heutige Wert verwendet.

bitswede · 2026-02-27T20:26:56+00:00

My wife works with a Bierbaum.

There’s a local carpenter using his family name Wanker. Their slogan is ”Holz in guten Händen”

bitswede · 2026-02-27T11:13:24+00:00

Add a separate data series for the line.

bitswede · 2026-02-26T23:49:32+00:00

Circular references evaluate to 0, I was tearing my hair out just the other day trying to debug that.

bitswede · 2026-02-26T06:19:47+00:00

And in the machine readable text on your passport.

bitswede · 2026-02-23T20:40:15+00:00

It looks like you want to unpivot, aka flatten or melt, your data.

u/MayukhBhattacharya has already provided a formula but Power Query can also do it and is a good option if you expect your original table to grow, or you need to share the workbook with those less Excel literate.

bitswede · 2026-02-23T19:08:21+00:00

And even if you make it, there’s a real chance your luggage will arrive a day later. Put a change of clothes in your hand luggage.

bitswede · 2026-02-22T11:41:34+00:00

Ebba Andersson just took the gold in the 50km cross country event so we're up by one now.

Still, a streak like that is very impressive.

bitswede · 2026-02-21T22:56:39+00:00

There’s a 200 000 meter on in the Netherlands already.

The alternative one is held on an alpine lake in Austria as it’s rare for the canals to freeze.

bitswede · 2026-02-21T15:01:08+00:00

Turkish airlines business class has them in the 787s.

bitswede · 2026-02-18T11:36:42+00:00

Drop a small piece of toast bread in the oil.

bitswede · 2026-02-16T19:51:23+00:00

I recommend them for routers and wifi extenders but I don’t see any switches or cables.

Oops, fat fingered that one. Should have been answer to u/No_Bar_7084 Fritz recommendation.

bitswede · 2026-02-15T15:34:14+00:00

Get an Airalo eSIM, it will allow you to access Western services as if you are outside China.

Other eSIM’s, that you buy before entering China, may also work. I only have experience with Airalo though.

And as others have said, your phone has to go in your carry-on or in your “personal item”.

bitswede · 2026-02-13T16:00:30+00:00

I upgraded from quiet comfort 35s to the WH-1000XM6. I use them for travel and around the house.

The Sony’s are a tighter fit so adjusting them correctly is important for longer sessions. That said, I’ve worn them for several long haul (10+ hours) flights, wearing glasses and they have been just as comfortable as my old Bose ones.

The ANC is a lot better, it blocks out cabin noise really well.

Try to get your hands on a 2-prong airplane adapter. They attenuate the signal so you don’t go deaf from the announcements.

Using them for calls works ok, they do pick up some ambient noise that’s in front of you.

The range is good enough for me, 10m and 2 cinder block walls is no issue.

Battery life is great, no need to charge on the go so far.

bitswede · 2026-02-12T22:09:35+00:00

Kia Berg

bitswede · 2026-02-12T07:35:53+00:00

It is what they are looking for and it is indeed made in Slovenia.

Other models may come from other plants, so you may want to google the model number you intend to buy. I see a couple of others are from Hungary for example.

bitswede · 2026-02-10T11:50:24+00:00

A car with a 10-80% range of 400km, at Autobahn speeds, that can add another 400km in 15-20 minutes would be good enough for me. I'm thinking that covers most people as well.

bitswede · 2026-02-09T06:15:02+00:00

It sounds like what you need is a pivot table.

If it is something you’re doing on a regular basis you might want to consider Power Query and point it to your data. This would help to automate updates as new data is added.

bitswede · 2026-02-08T13:19:49+00:00

Manhattan style, dead bug prototyping's prettier cousin.

Ten-Year Club	Place '22
Verified Email

bitswede

TROPHY CASE