| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parse contents of cell
Hi, Bellow I have examples of contents of cells with DWH fields. in Cell A1 I have: Srce_Inst Period_Dte Srce_Cr_Grade Cr_Grade_Qlfr_Cde (Each DWH field in cell A1 is separated by breaks (Alt+Enter) In cell A2 I have: Acc_Setup_Dte, Contract_Eff_Dte, Period_Dte (Each DWH field in cell A2 is separated by comas) My question is: Can I parse the contents of the cells? I want each DWH field of cells A1 and A2 to be in different cells: B1:Srce_Inst B2:Period_Dte B2:Srce_Cr_Grade B4:Cr_Grade_Qlfr_Cde B5:Acc_Setup_Dte B6:Contract_Eff_Dte B7:Period_Dte thanks! -- Portuga ------------------------------------------------------------------------ Portuga's Profile: http://www.excelforum.com/member.php...fo&userid=6385 View this thread: http://www.excelforum.com/showthread...hreadid=527056 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
