enviar numero de 4 cifras dividido

D

dragonfire33

Board Regular
Joined
Oct 7, 2021
Messages
91
Office Version
  1. 365
Platform
  1. Windows
buenas como puedo enviar cualquier numero de la columna "af:aj" automaticamente a las celdas a1,b1,c1,d1 como se muestra en la imagen tomando como ejemplo la celda F11
ec9bd1b1e93fcb5fd70158ef002fbb6e.png
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
You must log in or register to reply here.

Similar threads

D
  • Question Question
Realizar filtro de acuerdo a número de fila
Replies
4
Views
208
RobP
R
D
  • Question Question
Enviar a una columna los números únicos de acuerdo a un rango de datos
Replies
1
Views
238
Joe4
Joe4
D
  • Solved
Realizar filtro de acuerdo a valor de la celda
Replies
7
Views
271
dragonfire33
D
D
  • Question Question
Agregar código a formulario
Replies
0
Views
162
dragonfire33
D
D
  • Question Question
modificar codigo para resaltar en 3 celdas en linea
2
Replies
15
Views
720
DanteAmor
DanteAmor

Forum statistics

Threads
1,225,130
Messages
6,183,029
Members
453,146
Latest member
scarabeovini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top