COMMENTS | ID | NO | PR | Date |
ID: D66-1328 NO: II-550-254 PR: 1ABC D: 6/15/67 | D66-1328 | II-550-254 | 1ABC | 6/15/67 |
NO: II-550-254 PR: 1ABC D: 6/15/67 | II-550-254 | 1ABC | 6/15/67 |
Are these all in one cell?so my comments have many things and its saved like this :
ID: D66-1328
NO: II-550-254
PR: 1ABC
D: 6/15/67
Assuming you have the headers you show in Row 1, you can put this formula in cell B2 and copy it across to cell D2 (note that one column before the Date column) and then copy the range B2:D2 down to the end of your data. That will handle all but the date. The problem with the date values is it starts and ends with "D:" which is the same as the end of the ID marker, so we can't just search for "D:" as we will find "ID:" first. We will need a separate formula for that column. There are several way to approach the formula for the date value, so I have some questions about your comments...it will work "kind of" if I used your previous formula (instead of "D:" I put "PR:") and I got the answer (1ABCD: 6/15/67) so If I can add something to delete any thing after the "D:" this will help also.
You should never "simplify" your data for us when asking a question here as we design our solutions for what you say you have. Fortunately the change to my formula to account for your using ID instead of the actual DASH code word is a simple one. Use this formula in cells B2:D2 copied down...sorry for the confusion so I was giving an example (the Marker ID is DASH in the comments):
DASH: D66-1328
NO: II-550-254
PR: 1ABC
D: 6/15/67