Hi ~ Wondering if you could assist me with the Text import wizard to configure the columns and tab delimiter for the attached txt file. And then send me the steps.
I will be needing to do this every week to the same types of txt files, importing into Excel and I’d like to create a Macro for this but cannot figure out how to set the tab/columns. Thanks, Sunnie -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Date|Time|From|To|MessageContents 04/25/2011|06:54:00Robert L|2065409868|CCU-YELLOW(1).IMC-red(0).TELE-red(0).MS-GREEN(7).CURRENT CENSUS:210# OF ED PTS:8ED BOARDERS:4 tele 1 IMC.LAST DIVERT:2/16/2011There are 26 am and 60 total surgeries today.| 04/25/2011|09:32:39elaine|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 04/25/2011|11:10:42Elaine|2065409868|CCU- 1IMC- 0TELE-0 MS- 2 all areas redCURRENT CENSUS:213# OF ED PTS:22ED BOARDERS:3 2 tele 1 imcLAST DIVERT:2/16| 04/25/2011|03:58:40|2065409868|CCU- 1 redIMC- 0 redTELE- 3 yellowMS- 4 redCURRENT CENSUS:209# OF ED PTS:23ED BOARDERS:0LAST DIVERT:2/16| 04/25/2011|07:13:50|2065409868|CCU- 1 REDIMC-1 RED TELE- 4YELLOWMS- 10 GREENCURRENT CENSUS:211# OF ED PTS:21ED BOARDERS:0LAST DIVERT:2/16| 04/26/2011|12:28:52BILLIE|2065409868|CCU-1 IMC-1 TELE-1 MS- 6CURRENT CENSUS:227# OF ED PTS:5ED BOARDERS:0LAST DIVERT:02/16| 04/26/2011|06:57:19Billie|2065409868|CCU- 1IMC- 0TELE- 0MS- 7CURRENT CENSUS:229AM SURG:37IP SURG:4OP SURG:32TOTAL SURG: 73# OF ED PTS:3ED BOARDERS:1LAST DIVERT:02/16| 04/26/2011|09:48:31X10313|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 04/26/2011|11:45:35x10313|2065409868|CCU- 2IMC- 0TELE-0MS- 6CURRENT CENSUS: 223# OF ED PTS:9ED BOARDERS:0LAST DIVERT:2/16| 04/26/2011|03:56:55x10313|2065409868|CCU-2 IMC-0 TELE-0 MS-2 CURRENT CENSUS:218# OF ED PTS:10ED BOARDERS:0LAST DIVERT:2/16ED with 4 pts awaiting beds| 04/26/2011|04:12:47x10313|2065409868|Correction to Flow Alert:ED has 3 pts bording and 1 awaiting a bed, instead of 0 borders and 4 awaiting beds.| 04/26/2011|07:11:30x10313|2065409868|CCU-0IMC-0TELE-0MS-0CURRENT CENSUS:228# OF ED PTS:11ED BOARDERS:2LAST DIVERT:2/16| 04/27/2011|12:36:45Robert L|2065409868|CCU-red(0).IMC-red(0).TELE-red(0).MS-yellow(4).CURRENT CENSUS:241# OF ED PTS:17ED BOARDERS:2 (IMC)LAST DIVERT:2/16/2011| 04/27/2011|07:11:20Robert L|2065409868|CCU-Red(0).IMC- Red(0).TELE-Red(0).MS-Red(4).CURRENT CENSUS:247.AM SURG:28IP SURG:4OP SURG:36TOTAL SURG:68# OF ED PTS:3ED BOARDERS:1 imc 1 rcmLAST DIVERT:2/16/2011| 04/27/2011|09:37:5910313|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 04/27/2011|11:01:53|2065409868|CCU- 0 REDIMC- 0 REDTELE-0 RED MS- 2 REDCURRENT CENSUS:242# OF ED PTS:15ED BOARDERS:4 (1 TELE, 1 IMC, 1 RCM, 1 MS)LAST DIVERT:2/16| 04/27/2011|06:47:48ELAINE|2065409868|CCU- 1+O/C YELLOWIMC- 1 REDTELE- 2 REDMS- 0 REDCURRENT CENSUS:230# OF ED PTS:18ED BOARDERS:9 5 MS, 3 BEDS PENDING, 2 IMC BEDS PENDING,2 RCM BEDS PENDINGLAST DIVERT:2/16| 04/28/2011|06:28:01Billie|2065409868|CCU-0 IMC- 0TELE- 1MS- 4CURRENT CENSUS:251AM SURG:35IP SURG:4OP SURG:33TOTAL SURG:72# OF ED PTS:2ED BOARDERS:1LAST DIVERT:02/16| 04/28/2011|07:34:37|2065409868|IV TEAM IS RUNNING SHORT 1 RN TODAY. PLEASE BE PATIENT WITH THEM. THANKS | 04/28/2011|09:49:41Robert L|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 04/28/2011|11:37:43Robert L|2065409868|CCU-red(0).IMC-red(0).TELE-red(0). MS-red(0). CURRENT CENSUS:246# OF ED PTS:12ED BOARDERS: 2 msLAST DIVERT:2/16/2011| 04/28/2011|03:20:43Robert L|2065409868|CCU-red(0).IMC-red(0).TELE-red(0).MS-red(1). CURRENT CENSUS:235# OF ED PTS:22ED BOARDERS: 1 imcLAST DIVERT:2/16/2011| 04/28/2011|06:42:39Robert L|2065409868|CCU-Green(2).IMC-red(0).TELE-red(1).MS-red(0).CURRENT CENSUS:255# OF ED PTS:16ED BOARDERS:2 msLAST DIVERT:2/16/2011| 04/29/2011|07:02:5810313|2065409868|CCU- 1IMC- 0TELE-1 MS- 6CURRENT CENSUS:262AM SURG:275IP SURG:1OP SURG:35TOTAL SURG:63# OF ED PTS:2ED BOARDERS:1 RCMLAST DIVERT:2/16| 04/29/2011|09:52:4810313|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 04/29/2011|12:09:2310313|2065409868|CCU- RED 1IMC- RED 0TELE- RED 0MS- RED 2CURRENT CENSUS:250# OF ED PTS:18ED BOARDERS: 1 TELELAST DIVERT:2/16| 04/29/2011|04:05:2910313|2065409868|CCU- RED 1IMC- RED 2TELE- RED 1 MS- RED 4CURRENT CENSUS:234# OF ED PTS:19ED BOARDERS:0LAST DIVERT: 2/16| 04/29/2011|07:08:5810313|2065409868|CCU- GREEN 2IMC- RED 1TELE- GREEN 4 MS- GREEN 5CURRENT CENSUS:233# OF ED PTS:23ED BOARDERS:0LAST DIVERT:2/16| 04/30/2011|09:29:30Jessica|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 04/30/2011|07:00:01bed ctr|2065409868|CCU- 2IMC- 3TELE- 3MS- 2CURRENT CENSUS:207# OF ED PTS:6ED BOARDERS:0LAST DIVERT:2/16| 05/01/2011|07:12:4310313|2065409868|CCU-3 IMC- 0TELE-0 MS- 3CURRENT CENSUS:211AM SURG:0IP SURG:1OP SURG:0TOTAL SURG:1# OF ED PTS:7ED BOARDERS:0LAST DIVERT:2/16| 05/01/2011|09:37:17FLOW|2065409868|Location: Bed ControlNeeds: Please come to 1000 bed huddle, thanks.| 05/01/2011|11:12:11FLOW|2065409868|CCU- 3IMC- 0TELE- 1 FEMALEMS- 4CURRENT CENSUS:214# OF ED PTS:7ED BOARDERS:1 RCM, 1 TELE MALELAST DIVERT:2/16| 05/01/2011|05:00:591700-1900|2065409868|CCU- 3IMC- 1TELE- 4MS- 8CURRENT CENSUS:193# OF ED PTS:4ED BOARDERS:0LAST DIVERT:2/16| 05/01/2011|07:30:08flow|2065409868|CCU- 1IMC- 0TELE- 5MS- 12CURRENT CENSUS:190# OF ED PTS:7ED BOARDERS:1LAST DIVERT:2/16/11| 05/01/2011|10:38:17BILLIE|2065409868|CCU- 1IMC-1 TELE-2 MS- 5+CURRENT CENSUS:196# OF ED PTS:7ED BOARDERS:0LAST DIVERT:02/16|
