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:
![sched_zpstba3mmju.png](/board/proxy.php?image=http%3A%2F%2Fi1064.photobucket.com%2Falbums%2Fu373%2Fdruminphreak%2Fsched_zpstba3mmju.png&hash=4a879c767f5fbe861eb6985bebdd64a4)
Any kind of help would be appreciated!