split data into excel using vb or macro

[shrinivasmj]

hi,

data

Ohv$R4EC$7 1 3 $MizvcfYNef7 VELDNA L. NENNE [email protected] +001 046 763899 F Kj1ycgYMef TDK$MizvcfYNef TDKTB7 1T "9503 LAKESHORE DRPueblo 461224 MD" "1 161 1 E. LENHERSCHWERIN TRA I L Memphis 232342" 78000000 7 1 33TD7 0 Y 2


UEW%VKXY%858%TAVYjFdplg8 NIKOIAL K.ELNA [email protected] +001 036 196491 F S$VYkDeqmh WOX%TAVYIFdplg WOXYD85W "5357 W. PORTAU PRINCE Coral 563081 WY" ''23708
CLAWTTERRD. Concord 551244" 70900000 8588WO8 0 Y 1




need to split the data using this step


1. TBC - first need to check space between 24 character and remove the space in between and space after 24 character

2.Name- check for before @ space ,and take the text to name field .

3. Mail- before@space to + sign take in email field

4.mobile- field take all start from + ends with (F) OR (M )and fields contains only numbers

5.***- F or M Single character

6.Lic- After M or F take 10 character

7.Gir- Take 14 character

8.Pan- take 8 character

9.House address- starts with " double code or Take all Caps in Address till find proper case words

10.House City- will be in proper case

11.House pin- take all numbers in pin 5 or 6 digits

12.house state- IN caps Latter 1 or 2 digits or ends with " double code

13.office address- starts with " double code or Take all Caps in Address till find proper case words

14.office city- will be in proper case

15.office pin- take all numbers in pin 5 or 6 digits ends with " double code

16.loan- start with " double code and take all numbers

17.MRN-take 7 character

18.AF- SINGLE DIGIT NO

19.NRI - Single character

20.CP- SINGLE DIGIT NO