Drumin_Phreak
New Member
- Joined
- Oct 10, 2016
- Messages
- 25
Hello,
I am currently trying to devise a way (using excel and vba), that whenever a number is entered followed by a string of text typically a imperial measurement abbreviation ("in", "ft", "Yrd"), The number is converted to a metric equivalent and the abbreviation is deleted. Here is a sample of the data I am working with:
Any kind of help would be appreciated!
I am currently trying to devise a way (using excel and vba), that whenever a number is entered followed by a string of text typically a imperial measurement abbreviation ("in", "ft", "Yrd"), The number is converted to a metric equivalent and the abbreviation is deleted. Here is a sample of the data I am working with:

Any kind of help would be appreciated!