• Blog
    • Excel
    • PPT
    • Power BI
    • VBA
    • Other
  • Training
    • Corporate Training
    • Online/Remote Training
    • Webinars/Seminars
  • Courses
      • All Courses
      • Microsoft Excel
      • Microsoft Access
      • Microsoft Outlook
      • Microsoft Power Point
      • Microsoft Word
      • Microsoft VBA
      • Microsoft Projects
      • Microsoft Publisher
      • Microsoft OneNote
      • Microsoft Office 365
      • Power BI Desktop
      • Microsoft Visio
      • Tableau
      • SharePoint End User
      • Miscellaneous Courses
      • Course Feedback
  • Certifications
    • Certifications Information
    • Microsoft Office Specialist
    • Adobe Certified Associate
    • QuickBooks Certified User
    • Autodesk Certification
  • Videos
    • Popular YouTube Tutorials
    • Recorded Webinars
  • Members Zone
    • Become A Member
    • Exclusive Video Tutorials
    • Quick Reference Guides
  • Home
  • About
  • Contact Us
  • Office Instructor
See How See How
See How See How
  • Blog
    • Excel
    • PPT
    • Power BI
    • VBA
    • Other
  • Training
    • Corporate Training
    • Online/Remote Training
    • Webinars/Seminars
  • Courses
      • All Courses
      • Microsoft Excel
      • Microsoft Access
      • Microsoft Outlook
      • Microsoft Power Point
      • Microsoft Word
      • Microsoft VBA
      • Microsoft Projects
      • Microsoft Publisher
      • Microsoft OneNote
      • Microsoft Office 365
      • Power BI Desktop
      • Microsoft Visio
      • Tableau
      • SharePoint End User
      • Miscellaneous Courses
      • Course Feedback
  • Certifications
    • Certifications Information
    • Microsoft Office Specialist
    • Adobe Certified Associate
    • QuickBooks Certified User
    • Autodesk Certification
  • Videos
    • Popular YouTube Tutorials
    • Recorded Webinars
  • Members Zone
    • Become A Member
    • Exclusive Video Tutorials
    • Quick Reference Guides
  • Login

Left

Splitting Text at the Second Uppercase letter… Functions, Power Query and More

No Comments

If you have a string of text, like a full name without spaces, and you want to split it into 2 columns: one for the first name and another one for the last name, you look for a pattern, like the chang...

Popular Posts From Blog

1

Color Hundreds of Sheet Tabs in One Step in Different Colors

918 views
2

XLOOKUP vs INDEX & MATCH for a Dynamic Chart

484 views
3

Pivot Table and Pivot Chart in PowerPoint… Are You Serious?

466 views

Used Tags

Absolute Advanced Filter Animation Cells CHAR Charts Code Consolidate Dashboard Date Math Dynamic Arrays EDATE Excel Flash Fill Functions IFERROR INDEX Left Macro MATCH Pivot Chart Pivot Table Pivot Tables PowerPoint Power Query Protection Ranges Relative Replace ROW Sheets Shortcuts Slicer Transpose VBA Visualization VLOOKUP Weekday Function XLOOKUP

About Us

Get in touch with us in the following ways.
info@see-how.ca
+1 (647) 290-0644
3303 Don Mills Road Suite 1402
Toronto Ontario M2J 4T6
Canada

Our Services

  • Corporate Training
  • Online Training
  • Live Seminars

Quick Links

  • Free Gift – Pivot Tables From Zero To Hero
  • Become A Member
  • Tutorial Videos
Copyright © See-How.ca
  • About
  • Contact Us
  • Office Instructor
Sign In

Remember Me

Lost Password
Lost Password

Please enter your username or email address. You will receive a link to create a new password via email.

Sign In