Get instant live expert help on I need help with alphanumeric code generator

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

how to convert alphanumeric into numeric only
Solved by F. J. in 13 mins
I am using drop down selections as an order sheet that searches the document to gather pricing from tables throughout various tabs. In the "order Generator" tab under the "Homeowner delivery" section i want it to show the estimated delivery duration when the price is generated.All the cells outlined in bright red in tabs "order Generator and Topsoil is what you need to refer to. i tried to color code these cells to help explain how it works.
Solved by S. F. in 30 mins
I have a number generator (randbetween(1,69)) that will generate a table of 5 numbers. I am trying to eliminate previous number rows from the generator.
Solved by Z. Y. in 18 mins
I have a table with 62 rows of data. We have 2 ways of referring to our departments within our organization, using our alphanumeric routing code or with the formal title. Most of the Excel data we receive is listed with the alphanumeric routing code and we are constantly having to look-up the name of that office to confirm who's data we are referring to, because don't have all 62 memorized. I want to add 2 columns into every sheet and say find the routing code in 1 cell to the left in my reference table and then in this field and one cell to the right, insert corresponding office name and higher HQs (both listed in reference tables). Thanks!
Solved by G. F. in 16 mins
I created a weekday column which displays Mon, Tue, Wed, etc. for example, May 05 2018 which appears as Sat in my weekday column actually contains an alphanumeric code behind it (1900-01-07). copy and paste values is not allowing me to erase this alpha numeric code in the back ground and I cannot create the pivot table I need. I simply need to summarize some data by weekday. please help!
Solved by V. J. in 15 mins