Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.
MIS-Interview Series-Q30 (VBA UDF Function)
39 Views • Jul 12, 2023
Description
Function Value_with_hypen(x As String)
find_hypen = InStr(x, "-")
first_value = Left(x, find_hypen - 1) + 0
second_value = Right(x, Len(x) - find_hypen) + 0
For i = first_value To second_value
qq = qq & "," & i
Next i
Value_with_hypen = Right(qq, Len(qq) - 1)
End Function
Supporting file can be downloaded from below path.
https://drive.google.com/file/d/1d60yBUh2Rhr5PVE7Fm2gPBl69fDH5yHQ/view?usp=sharing
Microsoft Excel Course: Advanced Excel Training
https://www.udemy.com/course/microsoft-excel-excel-from-beginner-to-advanced-m/?couponCode=FC0D30F148B3045E6E59
Keywords & Tags
More from User
39 Live SQL Practice Session 22 Feb 2026
RAKESH KUMAR
37 Live SQL Practice Session 1 Feb 2026
RAKESH KUMAR
36 Live SQL Practice Session 25 Jan 2026
RAKESH KUMAR
38 Live SQL Practice Session 15 Feb 20263
RAKESH KUMAR
35 Live SQL Practice Session 18 Jan 2026
RAKESH KUMAR
34 Live SQL Practice Session 11 Jan 2026
RAKESH KUMAR
Related Videos
Excel (Macro) VBA Part-2 | VBA - Cell Referencing | Debug Function - Step into | VBA Coding in Hindi
Tech Guru Plus(Nazim Khan)
MIS Excel VBA Macro Tips-2
RAKESH KUMAR
Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax
Shalanda Farrow
Excel (Macro) VBA Part-3 | Copy Data to another Sheet in Excel by Macro | VBA Coding in Hindi
Tech Guru Plus(Nazim Khan)
Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need | Read Books Online
Patriciabperron
[PDF] Holy Macro! It's 2,500 Excel VBA Examples: Every Snippet of Excel VBA Code You'll Ever Need | Read Books Online|Ebook Download
Gesta