|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Search a cell that contains words and numbers and convert the numbers to metric
I have an equipment list that displays pumps, filters and other equipment for my work. The list gives info like manufacture, model number, flows, head, areas and pipe sizes. The list is given in empirical units (feet, ft^2, inches, gallons, etc.) We create several of these lists everyday and a good majority of them need to be in metric units (meters, m^2, mm, cubic meters, cmh, etc.).
Our way of converting them now is to do it manually, double clicking the cell and entering the conversion. I would like to create code to do this for me, including the converting. I would like the code to look for the GPM or TDH or " (inch) and convert the number just before the units. I have attached a sample of what the list looks like, C3 shows the original content with empirical units and C4 shows what we would like after the conversion to metric. Before I write code I would like to know if it's even possible. I'm not sure if it's possible because the flows can range from 2 digits to 5 digits and I'm having a hard time coming up with a way to search a cell for a number that have a different amount of digits. Other number data might be different as well. Thanks for any help. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Words in my document were converted to numbers???? | MikeD23 | Word | 1 | 08-26-2012 11:09 AM |
can word convert numbers? | koolfire | Word | 2 | 01-07-2012 02:12 PM |
Convert numbers to a specific text string | francis | Excel | 1 | 10-06-2011 01:43 PM |
Numbers in Words | janak | Excel | 2 | 12-19-2010 08:53 PM |
Numbers Convert in word in MS Access | towhid | Office | 0 | 08-19-2010 01:17 AM |