title: Copy only Employee id to excel sheet
body: <p>I have a unformatted data containing in Notepad file as shown below.</p>
  <pre><code>#Civil
  GROUP CIVIL RPatel66 LKohli12 m12 PSen72 m72
  GROUP CIVIL SKumar22 ASekar32 m32 BSiva90 
  #Mechanical
  GROUP MECHANICAL OKhan78 m78 MShah81 JKumar11 
  GROUP MECHANICAL VHiremath12 TVasu43 m43 NReddy21
  #Electrical
  GROUP ELECTRICAL LPathan88 SPatil56 m56 AParth33
  GROUP ELECTRICAL HAnil45 m45 Khari67 m67 Skumar49
  </code></pre>
  <p>When i run the below code</p>
  <pre><code>from openpyxl import Workbook
  wb = Workbook()
  ws = wb.active
  f = open('C:\\Users\\Kiran\\Desktop\\Input.txt', 'r+') 
  data = f.readlines()
  spaces = &quot;&quot;
  for i in range(len(data)):
      row = data[i].split(&quot; &quot;)  
      ws.append(row)
  wb.save(&quot;Output1.xlsx&quot;)
  
  import openpyxl
  book= openpyxl.load_workbook('Output1.xlsx')
  sheet = book['Sheet']
  sheet.delete_cols(1,2) #deletes Column 1 and 2
  book.save(&quot;Output1.xlsx&quot;) 
  </code></pre>
  <p>For the above i am getting error and not getting the required output as i need.</p>
  <p>I need output in a excel sheet as shown below.I need output as Eg:Rpatel66,LKohli12 etc in the excel sheet it should not contain m12,m72</p>
  <pre><code>RPatel66
  LKohli12
  PSen72
  SKumar22 
  ASekar32
  BSiva90
  OKhan78
  MShah81
  JKumar11
  VHiremath12
  TVasu43
  NReddy21
  LPathan88
  SPatil56
  AParth33
  HAnil45
  Khari67
  Skumar49
  </code></pre>