Wednesday, January 5, 2022

How To Generate Random Alpha Numeric Strings In A Range In Excel?

 =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(100,10000)&CHAR(RANDBETWEEN(65,90))

at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How not to fill filtered out cells when dragging down from another sheet

Steps: Apply your filter in Sheet1 . Select the range where you want to paste the formula (e.g., A2:A100 ) but only visible cells will...