Skip to Content
0
Jun 06, 2016 at 06:26 PM

UDF for Alphanumeric split

87 Views

Please find the requirement below and provide solution. The alphanumeric value should be separated,multiplied and combined with "-". Thanks in advance.

example 1:

Input = 2.5XV

Output = 025-XV

example 2:

Input = 3V

Output = 030-V

example 3:

Input = 14.5Z

Output = 145-Z