Hi, thsi is David (again...oh gosh )
From 2 Cell ( Cell C-9 and Cell C-38) I'm Extracting Numbers that MATCH Using GetMatch Function
(in reality i'm extacting match in more than 30 String)
Cell C9 -> 04-12-28-14-30-09-25-11-27-35-05-13-02-08-18-21-26-32
Cell C38-> 36-19-26-29-31-32-08-15-20-33-01-06-02-07-16-23-03-18
The GetMatch Function i copy in Cell in E34,
and in Cell E-34 Im Getting This -> 01 02 08 15 16 18 19 20 26 32 36 <- (No Dash)
WHAT I NEED TO GET IS THE SAME RESULT BUT WITH THE DASH -> 01-02-08-15-16-18-19-20-26-32-36
Question :
Please where in the Formula do i have to Insert the two quote and Dash? "-"
I'm using this Formula![]()
=GetMatch(C9,C38)
Thank You !!
Best Regards
David
Bookmarks