Is there any formula or UDF to Split House Numbers which is shown in the attached file and join in a Regular Pattern. Any Help Will be Very Useful. The Whole Pattern is Described in the Attached file. The Raw Data is in Column A and I Want the Output which is shown in Column H.
Thanks in Advance.
Thanks in Advance.