Did you ever wonder if there was an Excel formula that could split a text into columns or rows? Well, there is now! Introducing Split Text XL, which provides the SPLITTEXT formula. Use the SPLITTEXT formula to split text to columns or rows by a specified delimiter. The formula works similar to the “Text to … Continue reading Split Text to Columns or Rows in Excel
This is an article to demonstrate how to show line numbers in your Office macros. Why would you want to show line numbers in your Office VBA code? Most importantly, line numbers help in debugging your code. By default, it’s pretty difficult to find the location of an error in an Office macro because Office … Continue reading Lines Numbers in Office Macros
The newest version of CodeLiner has an option to customize your starting line number! CodeLiner shows line numbers in your VBA macros. Why are line numbers so important? Well, did you ever notice that the Erl function always returns 0 in your Office code? That’s because Erl requires line numbers in order to work properly. … Continue reading Version 6.0 of CodeLiner
Get new content delivered directly to your inbox.