Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

Fixed-Width

How To Export Excel Spreadsheet To A Fixed-Width Text File

September 4, 2013September 4, 2013 Kent ChenTips & Tricks

The easy way is to Save As to a Formatted Text file (Space Delimited)(*.prn). But you will be struggled to find out that it’s really hard to precisely specify the fixed-width, almost impossible to use to export the data into a perfect space aligned text file. What I am luck to find out is this with VBA. It’s a far […]

Read more
  • image - Why Office 365 GPO Settings Don't Apply? And What To Do?
    Why Office 365 GPO Settings Don’t Apply? And What To Do?
  • PowerShell
    Taking Screenshots with PowerShell on Windows 10
  • image 7 - Fix Windows 10 20H2 Upgrade Error 0xc1900223 via WSUS
    Fix Windows 10 20H2 Upgrade Error 0xc1900223 via WSUS
  • image 3 - How To Connect-MsolService without Login Prompt
    How To Connect-MsolService without Login Prompt
  • directory synchronization - How To Convert A Cloud Account to Azure AD Synced Account in Microsoft 365?
    How To Convert A Cloud Account to Azure AD Synced Account in Microsoft 365?

KC's Blog

  • Home
  • About Me
  • Sitemap
Powered by WordPress | Theme: Astrid by aThemes.