Split Data Techniques in Excel / POWER BI | POWER QUERY | Non Breaking Spaces, Delimiters, Lower & Upper Case Split & Numbers in a Separate Column! #(00A0) is Power Query code for a nbsp character. In word processing and digital typesetting, a nonbreaking space, , also called NBSP, required space, hard space, or fixed space (though it is not of fixed width), is a space character that prevents an automatic line break at its position. | Excel Basement