Find numbers within a string in Excel

Recently, I had to pull customer numbers out of strings from an excel sheet. Sure,  you can use trickery like spaces to columns or regex. Excel is pretty powerful, if you know all of the text tools at your disposal. This is how I extracted the numbers for random text

Continue reading “Find numbers within a string in Excel”

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter

Working with Seconds in Excel

I recently had to use back end data from SQL Server to deliver several reports in excel. All of my SQL code gave me results in seconds; however, the users had distinct formatting requests. I would have to use a few excel tricks to get things just right in each report.
Continue reading “Working with Seconds in Excel”

Rudy

Rudy Rodarte is a SQL Server Database professional based in Austin, TX. Over his career, Rudy has worked with SSRS, SSIS, performance tuning troubleshooting. When away from Keyboard, Rudy goes to Spurs and Baylor Bear sporting events.

More Posts - Website - Twitter

Importing Data into SQL Server – Using Excel Shortcuts


Fatal error: Uncaught Error: Call to a member function id() on array in /homepages/13/d308843217/htdocs/rodolforodarte/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php:36 Stack trace: #0 /homepages/13/d308843217/htdocs/rodolforodarte/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php(538): CrayonFormatter::format_code('', Array, Object(CrayonHighlighter)) #1 [internal function]: CrayonFormatter::delim_to_internal(Array) #2 /homepages/13/d308843217/htdocs/rodolforodarte/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php(516): preg_replace_callback('#()#msi', 'CrayonFormatter...', 'INSERT INTO Cou...') #3 /homepages/13/d308843217/htdocs/rodolforodarte/wp-content/plugins/crayon-syntax-highlighter/crayon_highlighter.class.php(166): CrayonFormatter::format_mixed_code('INSERT INTO Cou...', Object(CrayonLang), Object(CrayonHighlighter)) #4 /homepages/13/d308843217/htdocs/rodolforodarte/wp-content/plugins/crayon-syntax-highlighter/crayon_highlighter.class.php(186): in /homepages/13/d308843217/htdocs/rodolforodarte/wp-content/plugins/crayon-syntax-highlighter/crayon_formatter.class.php on line 36