Get all combinations

in2ition

New Member
Joined
Mar 27, 2013
Messages
2
Hello everyone,

I have the following table:

ABCDE
26007201010391162102
26007201010391192101
26007202010391162202
26007202010391192201
26007202020391162204
26007202020391192203
26007203010391162302
26007203010391192301
26007203020391162304
26007203020391192303
26007204010391162402
26007204010391192401
26007204020391162404
26007204020391192403
26007205010391162502
26007205010391192501
26007205020391162504
26007205020391192503
26007206010391162601
26007206010391192601
26007206020391162601
26007206020391192601

<tbody>
</tbody>


Is there a way to automatically generate a * like in the below example ?

I will take only the first two combinations:
ABCDE
26007201010391162102
2600720101039116*
26007201010391192101
2600720101039119*
2600720101039*2101
2600720101039*2102
2600720101*1162102
2600720101*1192101
2600720101***
26007201*0391162102
26007201*039116*
26007201*0391192101
26007201*039119*
26007201*039**
26007201**116*
26007201**119*
26007201***2101
26007201***2102
26007201****

<tbody>
</tbody>


Thank you.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,203,236
Messages
6,054,297
Members
444,715
Latest member
GlitchHawk

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