How to add 2 random characters in random sequences but not at the beginning or end.

[rebel123]

Correct Answer is in green.

I added two dashes and 1 comma in each line in a random order.
However, I did not add it in the beginning or end of the line.

Thanks

 

[rebel123]

File is uploaded here.

112.xlsx

docs.google.com

 

[Cubist]

Try:

Book1
	A	B
1
2	1707364001002002	17073640.01-0020-02
3	6830002630310100000100	683000-26.30310-100000100
4	22-00-31-2-017-006.000	2-.2-00-31-2-017-0-06.000
5	0129002030170020000000	01-2900.203017002000-0000
Sheet5

Cell Formulas
Range	Formula
B2:B5	B2	=LET(r,REDUCE(A2,RANDARRAY(2,,2,LEN(A2)-1,1),LAMBDA(x,y,REPLACE(x,y,0,"-"))),REPLACE(r,RANDBETWEEN(2,LEN(r)-1),0,"."))

 

[rebel123]

can u send file? I tried it and it did not work. I might be doing it wrong!

 

[Cubist]

can u send file?

You can copy the mini-sheet using the top left icon.

I tried it and it did not work

What didn't work?
Are you using Excel or Google Sheets?

 

[rebel123]

i have no idea. where the mini sheet is?

 

[Cubist]

where the mini sheet is?

The mini-sheet is is in post #3. I showed how you can copy it it in post #5.

i have no idea.

You have no idea about what? Whether you're using Excel or Google Sheets? Or why is it not working?

 

[rebel123]

i have no idea how to use the website. i was using it in excel and not google docs. I tried it in both and it did not work,

112 REVISED.xlsx

docs.google.com

 

[Cubist]

i have no idea how to use the website. i was using it in excel and not google docs. I tried it in both and it did not work,

112 REVISED.xlsx

docs.google.com

It is not a website. It's a feature of the forum. If you test in Google Sheets it won't work.

 

[rebel123]

OK thanks. I will figure it out. I will mark it as resolved!