Need to add a prefix in a workbook for different category. like
analyzer 600
autoclave 601
balances 603
Need to add a prefix in a workbook for different category. like
analyzer 600
autoclave 601
balances 603
Please explain more carefully what data you have and what results you want.
When I say semicolon, u say comma!
Category Product Number Description
Analyzer 490000 Microtrac particle analyzer (3 pcs)
Analyzer 490001 3300 IR gas analyzer
Analyzer 490002 TGA-7 thermogravitmetric analyzer.Analyzer 490014 B-641 thermal cycler
Autoclave 490061 vertical 14 x 26 inch autoclave.
Balances 490062 HM-120 analytical balance with 0.1 mg readability and 120 gm capacity.Balances 490135 top loading electronic balance with 1mg readability and 500 gram capacity.
Balances 490136 YPD 02 printer.
Bath 490137 Model B7000-67 water bath. 6 x 12 x 6 inch deep.
Bath 490217 Model 270 high performance 89 liter capacity digital heated circulating water bath with cover.
Bath 490218 Model 280 general purpose water bath digital controls & display 1.5 liter capacity (6" x 11.4" x 2") 100oC maximum temperature and stainless steel gable coBiohood 490263 3' wide
Biohood 490264 4' Model NU408-FM 400 Class IIA biological safety cabinet.
Biohood 490286 Nua Model 425-600 Class IIA/B3 biohood/biological safety cabinet with stand. (Stand not shown in photo)
Cell Disrupters 490293 French Press with FA-073 cell.
Cell Disrupters 490294 Model FA078 French Press with FAO72 20 000 psi cell.
Centrifuges 490339 buckets for 276 rotor
Centrifuges 490340 40 ultra
Centrifuges 490584 Z320 8 x 15ml centrifuge.
Chromatography 490585 2089 uvicord III
Chromatography 490586 2117 multiphor with fluorometer
ontrol unit and 280nm filter.
Chromatography 490609 Vanta column 6.0cm
Desiccators 490610 Nalgene vacuum dessicator with H rack
Desiccators 490611 plastic vacuum dessicator with cover and plateDesiccators 490626 x 10 plastic dessicator box with shelf.
Evaporators 490627 4322000 vortex evaporator.
Evaporators 490628 113 multivp Nitro O
Evaporators 490629 43750/14 TurboVap LV high speed.Evaporators 490660 ZW640-3
Fermentors 490661 Bioflow III batch/continuous fermentor with 6 liter glass vessel and nutrient acid base and antifoam pumps and controls.
Fermentors 490662 fermenter vessels 2L with head plate
Fermentors 490663 Model ph 40 controllerFermentors 490670 System 1 cell culture
Furnace 490671 495A furnace.
Furnace 490672 5 x 8 inch tube furnace with 59344 controller
Gas Chromatographs 490678 Model N611-9000-1023-2 autosystem gas chromatograph with FID ECD and autosampler.
Gas Chromatographs 490679 Sig 2000 dual FID GCGas Chromatographs 490690 Sig 3B FID & TCD GC
Glove Boxes 490691 3025 temperature controlled anaerobic chamber with glove ports.
Glove Boxes 490692 4 glove single side with stainless chamber.Glove Boxes 490700 stainless steel 2-sided glove box with dual column gas dryer. 3 vacuum pumps and 2 recirculating chillers. Factory reconditioned.
Microscopes 490701 Bullpen compound laboratory microscope with trinocular head for camera mechanical stage and 4x 10x 40x and 100x oil planachromat objectives.
Microscopes 490702 binocular student microscope with mirror and 4 objectives 15x eyepiece.Microscopes 490743 SMZ-10T trinocular stereozoom microscope wih 6.6X to 40X zoom range and Dolan
Microscopes 490753 Universal phase and fluorescence.
Reactors 490754 glass reactor bio type
Reactors 490755 30 liter glass reactor vessel with bottom valve support assembly air motor stirring shaft and agitator. Priced without reactor head.
Reactors 490756 4522 packed drive reactorReactors 490768 RMaxi reaction instrument.
Spectrophotometers 490769 Spec 20 visible range spectrophotometer.
Spectrophotometers 490770 Spec 20 visible range spectrophotometer. Spectral range 340 to 600nm.
Spectrophotometers 490771 Spec 20 spectrophotometeSpectrophotometers 490814 Ultro uv/vis spectrophotometer with 6 place cell holder scanning printer 200 to 900 nm range.
Ultrasonic Cleaners 490815 9332 ultrasonic cleaner
Ultrasonic Cleaners 490824 SE-40 ultrasonic cleaner 6" x 6" x 3" deep chamber.
this is my data and I need to add a prefix to this , analyzer is 600 all the way to Ultrasonic cleaner is 635. Just dont know how and I have only been using excel about 3 weeks.
Ok maybe it's my english but what exactly do you mean by prefix? Do you want to insert a column to the left of your data? Do you want to add text to some cell values?
In my book it says
use the CONCATENATE function to add the appropriate prefix and a dash to each category.
so it needs to look like 600-analyzer
Ah I understand. Now, do you have to make a new cell that says "600- analyzer" and keep the original cell with "analyzer"?
In that case typ in your new cell this formula: ="600- "&A1
Is that what you need?
Hi and welcome to the forum
I would suggest that you 1st create a small table with all the unique categories and associated values in. Something like this...
Analyzer......600
Autoclave....601
Balances......603
Bath...
Biohood...
etc. I used S2:T20. Then I added an extra column at B and used this, copied down...
=VLOOKUP(A2,$S$2:$T$20,2,0)&" - "&A2
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Did you put analyzer....600 in S2
autoclave.....601 in S3
where does the T20 come in at
Can the T20 be S19 instead in the formula
I think I go that the wrong way round, sorry.I used S2:T20. Then I added an extra column at B and used this, copied down...
=VLOOKUP(A2,$S$2:$T$20,2,0)&" - "&A2
1. Insert a new column after A
2. copy this to B2, andthen copy down...
=VLOOKUP(A2,$S$2:$T$20,2,0)&" - "&A2
3. in S2:T20, create a table that contains the unique categories in S and the value in T
See the attached file
Last edited by FDibbins; 08-04-2013 at 04:24 PM.
=VLOOKUP(A2,$S$2:T$20,2,0)&"-"&A2
this is what I put in but get 0 where Analyzer is
I need to add column
first , sorry.
Did my file give/show you what you wanted?
trying to add column now and then I think it will work. When I add a column is puts everthing in B to Column C is that correct
After I get this step done , I have to change data set to an Excel Table and display top 20 items
Yes it is
.
Thank You for all your help. I will be working out more as the day goes.
OK good, lt me know how you make out?
Really saved the day!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks