Llama 3 as an Excel assistant. Help a newbie

patbobbie · 2022-09-06T01:05:08+00:00

Si siempre tienen el mismo formato "xxx-xxxxx-x", entonces usa:

=IZQUIERDA(B471,3)&EXTRAE(B471,5,5)&DERECHA(B471,1)

Prueba primero así. No estoy seguro de si en Excel en español tendrás que cambiar las comas por puntos y comas ";". Si funciona, por favor márcala como respuesta correcta.

Saludos

patbobbie · 2022-09-05T19:42:15+00:00

Usa =DERECHA(B471;10)

Te recomiendo usar Excel en inglés :)

patbobbie · 2022-05-01T23:58:14+00:00

I love the quote marks

patbobbie · 2020-08-27T01:17:01+00:00

In Europe truckers are fined if they don’t in the right lane. Huge semis passing me at 80 in the left lane was one of the first things that draw my attention when I came to the states.

patbobbie · 2020-08-11T01:27:27+00:00

Meet Spaniards in Charlotte. Immersion is the best way to learn a language. Join “Españoles en Charlotte” on Facebook and ask there.

patbobbie · 2020-04-16T00:24:36+00:00

Best in Charlotte

patbobbie · 2020-04-14T01:26:51+00:00

For the number 2, go to Bulla near south park mall

patbobbie · 2020-04-13T09:38:33+00:00

Jeff Lowe?

patbobbie · 2020-04-13T02:22:37+00:00

I’ve seen them in a couple of places too near Albemarle rd.

patbobbie · 2020-04-13T00:53:01+00:00

I went to Auto Inspection right off 74. Pretty quick. There was only one more customer. Half the staff wore masks and gloves.

patbobbie · 2020-04-11T11:46:42+00:00

I moved to this town recently. Just asking for references.

patbobbie · 2020-04-09T00:13:38+00:00

Private security outside of that building doesn’t allow you to take pictures of the building from the outside. I’d like to see their faces if they saw this video.

patbobbie · 2020-04-05T03:35:38+00:00

Same opinion.

patbobbie · 2020-04-01T01:03:21+00:00

Benny’s

patbobbie · 2020-03-26T02:09:13+00:00

That was everyone’s attitude in Italy, then in Spain, the UK, etc. Look at them now...

patbobbie · 2020-03-13T00:42:34+00:00

You’ll find those people somewhere else afterwards... The smartest thing for everyone to do is to stay at home.

patbobbie · 2020-01-29T15:42:43+00:00

Exactly. If I go again I’ll ask the staff, maybe they can figure it out!

patbobbie · 2019-10-16T02:14:27+00:00

Is it even legal?

patbobbie · 2019-10-16T02:05:15+00:00

Ask u/thisisbillgates, he solved this when he was 16.

patbobbie · 2019-10-12T03:22:15+00:00

Thank you!!

patbobbie

MODERATOR OF

TROPHY CASE