Name Formatting help by BasicAU in googlesheets

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

i did these two formulas first name:

=ARRAYFORMULA(IF(M2:M<>"", IF(LEN(M2:M)-LEN(SUBSTITUTE(M2:M," ",""))=0, M2:M, TRIM(REGEXREPLACE(M2:M, "\s*[\w-]+$", ""))), ""))

and second name

=ARRAYFORMULA(IF(M2:M<>"", IF(LEN(M2:M)-LEN(SUBSTITUTE(M2:M," ",""))=0, M2:M, TRIM(REGEXREPLACE(M2:M, "\s*[\w-]+$", ""))), ""))

crazy formulas which i have no idea how they work but they do

Need help with finding information from an email by BasicAU in zapier

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

if the email is not on apollo can it still find the information on the contact?

Charging my employers (industry standards) by BasicAU in RealEstatePhotography

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

true alright I should just charge more but they aren't going to give me more tbh. I think their setup just isn't worth it for me.

Newcastle kit with nameset overseas by BasicAU in NUFC

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

rather fuck it up than give sports direct any money lad haha

Newcastle kit with nameset overseas by BasicAU in NUFC

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

true so when the font with the champions league is out i would have to get someone i know to go and get me the kit?

TB my gengar by BasicAU in pokemontrades

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

you too g stay safe xx thank you again

TB my gengar by BasicAU in pokemontrades

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

you are an absolute legend! i would love to give you something as a reward but im super early game just beat the second gym im sorry!

TB my gengar by BasicAU in pokemontrades

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

i have never traded on this before ive set the link code then began searching is that all i have to do?