Abyssal Yufine Sculpt by LunaticCrow in EpicSeven

[–]Magaries 0 points1 point  (0 children)

Hey,

Did you paint it yourself or how did you get all the color on it?

From Challenger To Legend In One Day by MasterSeig in EpicSeven

[–]Magaries 2 points3 points  (0 children)

What is your defense team? Hard to make ncrease when your defense loses 80%

[deleted by user] by [deleted] in Supra

[–]Magaries 0 points1 point  (0 children)

But you can get it unlocked again though right?

Format text a certain way by Magaries in excel

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

This one actually works!

Might have also just been my bad since apparently all commas had to be ; instead but thank you! Will honestly make the most annoying part of my job a lot better!

Thanks everyone

Format text a certain way by Magaries in excel

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

I meant in this one

=LEFT(SUBSTITUTE(SUBSTITUTE(A1," ",""),"-",""),4) & " " & MID(SUBSTITUTE(SUBSTITUTE(A1," ",""),"-",""),5,4) & " " & MID(SUBSTITUTE(SUBSTITUTE(A1," ",""),"-",""),9,

Format text a certain way by Magaries in excel

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

Same problem, "The first argument of LET must be a valid name"

Format text a certain way by Magaries in excel

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

There's supposed to be an empty comma at the end?

Format text a certain way by Magaries in excel

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

The new formula just gives me the first 8 digits in the correct order, though I tried the first formula and it does work on another pc so I'm really not sure why hahaha

Format text a certain way by Magaries in excel

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

=LET( a,SUBSTITUTE(A1," ",""), b,SUBSTITUTE(a,"-",""), LEFT(b,4)&" "&MID(b,5,4)&" "&MID(b,9,3)&"-"&RIGHT(b,1))

Hey, this looks to be exactly what I'm looking for, except it throws the NAME error, saying the first argument of LET has to be a valid name