# Get instant live expert help on I need help with part number generator excel

“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

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
Using MS Excel I have a list of part numbers, 90k, with the part number, a semi colon and another number after the semi colon. I want to remove all the numbers after the semi colon on each part number. Is there a way to easily accomplish this?
Solved by C. J. in 24 mins
I have a three column excel spreadsheet with part number, quantity, and price. The part number field is not unique and repeats with every different quantity and price break. I need to reformat the data set so the part number is unique with all the quantities and pricing extending in the same row.
Solved by X. B. in 29 mins
I have a combination of packing lists. The parts are listed under headings. Only the first item has the part number. I want to allocate that part number to the other items in the list. For example the first number in column A is "Part 1", there are 15 sub parts in the "part 1" bundle. I want them all to be noted as "Part 1". The next number in column A is "Part 2" item is "Part 2", there are three sub parts. I want them to be noted as "Part 2". What I am looking for is a formula that will read the first number and allocate to the following blank entries until the next Part number is found.
Solved by A. A. in 26 mins
I need to update an excel sheet with new pricing - I have part numbers so i need to use the part number and use that as a key to update the pricing
Solved by K. E. in 11 mins