Excel VALUE FunctionVALUE() will convert a text string that represents a number into a number. Thus, the function will convert […] February 12, 2023 in Excel tagged value / number / format / text / convert by Mike
Text Transformation in Power QueryThis post covers a few common text transformations in Power Query. When you are working with a column, […] December 25, 2022 in Excel tagged merge / split / delimiter / capitalization / upper / proper / text / case / Power Query Transform by Mike
Power Query Transform Phone NumberDo you need to split a column of imported Excel telephone number data into two columns so that […] October 16, 2022 in Excel tagged excel / text / import / query / power / transform / Power Query Transform by Mike
Import a Text File into ExcelHow do you import a text file of data into Microsoft Excel? Let’s discuss two different ways of […] October 16, 2022 in Excel tagged wizard / file / text / import / open by Mike
Microsoft PowerToysPowerToys is a set of free utilities for Windows. Power users can tune and streamline their Windows experience […] July 27, 2022 in Windows tagged top / power / utilities / Windows / toys / color / rename / text / resizer / mouse / shortcut / always / resize / keyboard / image / zone by Mike
Splitting a Large Text FileSome text files are so large that they become difficult to work with. For example, If you try […] November 14, 2021 in Database tagged file / text / csv / git / Bash / split / tsv / large by Mike
WPF Convert a Number to TextCheque-writing applications require the conversion of a currency amount to be converted into text so that the words […] May 16, 2020 in WPF tagged cheque / text / convert / check / number / dollar / currency / words / cents / recursion by Mike
WPF TextBox Only Accepts AlphaThis WPF small project will demonstrate how to create a TextBox that only accepts alpha characters and spaces. […] May 16, 2020 in WPF tagged text / validation / validate / regex / input / alpha / preview by Mike
WPF RichTextBox ControlThe RichTextBox control is a more advanced TextBox that can contain formatted text and arbitrary objects embedded in […] April 24, 2020 in WPF tagged rich / richtextbox / text / control / box by Mike
WPF LabelThe WPF Label control is a content control that doesn’t have the notion of being clicked (like a […] April 17, 2020 in WPF tagged display / text / key / access / label / Textbox / focus by Mike
WPF Brushes and TextMicrosoft says: “You can also use brushes to apply rendering characteristics to text elements. For example, the Foreground […] April 12, 2020 in WPF tagged color / text / brush / gradient / brushes / multi-colored / WPF Brushes by Mike
WPF TextBlock ControlThe TextBlock allows you to put text on the screen, much like a Label control does. A common […] April 2, 2020 in WPF tagged linebreak / style / newline / text / textblock / span / run / line / wrap / inlines / break by Mike