Formula in excel

Copper Contributor

Sir assume I type 123 in cell

Now I want to show this number with formula in different ways like  want to show 213-231-321-312-132 also want to use for ABC 

2 Replies

Hi @Hiteshjaidka 

 

Since there are only 3 characters for the combination, I think you can get away with it by doing something like below:

 

Screenshot 2024-01-04 at 7.06.20 PM.png

 

 

Thanks for। reply sir but not helpfull this,