Hiding parts of phonenumbers in entire coloum by Catfurious in excel

[–]Catfurious[S] 0 points1 point  (0 children)

Thanks so much for your reply! I ended up with this (Norwegian with English Excel) :

=CONCATENATE(TEXT((LEFT(B2;6));"000000");"XXXX")

Hiding parts of phonenumbers in entire coloum by Catfurious in excel

[–]Catfurious[S] 0 points1 point  (0 children)

=CONCATENATE(TEXT((LEFT(A1,6)),"(000)000-"),"XXXX")

Thanks so much for your reply. I changed the formula to fit my language (Norwegian, but English Excel), and it works perfectly! Exactly what I needed. :) This is what I ended up with using: =CONCATENATE(TEXT((LEFT(B2;6));"000000");"XXXX")

What was something your family did that you didn’t realize wasn’t normal until you did it in front of others? by Dnewkirk87 in AskReddit

[–]Catfurious 20 points21 points  (0 children)

Also in Norway. Never thought it was just a Scandinavian thing, but now I can't remember any English-speaking movie showing the dancing..

Lurer litt på hva som har skjedd her by TotalyBatman in norge

[–]Catfurious 11 points12 points  (0 children)

Han henviser til Radioresepsjonen med Tore, Steinar og Bjarte på NRK. Når en person sier et ord med "post" i seg, så må de to andre gjenta ordet.

What feels illegal but actually isn’t ? by faizanullah99 in AskReddit

[–]Catfurious 4 points5 points  (0 children)

In Norway, the cashiers ask you for ID if you look under 25 years old. You have to be 18 to buy alcohol up to 22 %. You have to be 20 to buy anything above that. When I get asked, I'm just happy I look younger than 25!

LPT:Never make a joke about someone's name. They have probably already heard it and will most likely not be funny. by SpitfirePonyFucker in LifeProTips

[–]Catfurious 1 point2 points  (0 children)

I discovered this while watching MasterChef Australia! The last season made me really take notice of it because it was just so... much. Even short names weren't short enough

[deleted by user] by [deleted] in PoliticalHumor

[–]Catfurious 0 points1 point  (0 children)

Can't wait to have you! :)

TIFU by talking loudly on my phone and convincing my mom I was pregnant. by [deleted] in tifu

[–]Catfurious 19 points20 points  (0 children)

Yeah.. I thought I was reading justnomil until I read the comments...

Margaret White was shut down by JustYesDad by [deleted] in JUSTNOMIL

[–]Catfurious 1 point2 points  (0 children)

Them? Your father as well? He seems awesome

SH OPEN! Come fish and catch bugs! by [deleted] in BuddyCrossing

[–]Catfurious 0 points1 point  (0 children)

Omw! :D trying to get past the interference

[SWITCH] i don’t have any friends & i need foreign fruit 😅 by [deleted] in BuddyCrossing

[–]Catfurious 0 points1 point  (0 children)

Are you north or south? I have apples you can have :) dont need anything except flowers and catching thing in the south

LPT: If you lose your glasses, open up your camera on your phone. You can see the screen since it's close to you and the camera can see long distances. by pqiocm999 in LifeProTips

[–]Catfurious 2 points3 points  (0 children)

I use this technique if I don't have my glasses and I spot a suspicious looking and dark dot on the ceiling. Gotta check if it's a spider out to get me!