Hi Sarah

Tip #5 helps sort out any funky goings-on with text in Excel

https://lh6.googleusercontent.com/iWEr9IJMh7LzhaONYxqZjK0dlnPo4PEYOrNXohiQdVEvCcD2ldQKBxNVFKYk5Oa4xp5R_K6M50u0-SqR66b-NOhg0_6yHA_TozPgiR7tkGUz6-BS0JloCwhD4upbQlNFt7IeQhS9

=PROPER(cell reference)

Will adjust any text to proper sentence case.

https://lh5.googleusercontent.com/33Rra9hhtIXkooSRcCLn3veXFrwV_fy4TZ8cll-FExjk2NfBtUEv6P1xPR8PCTN_VJ2HqIWuPstUnWJIGcrzyNvNFuREcLrC5GPlbE2JCDfcRIgs04zWape0aTXMWsKFQkETQls5

It’s PROPER good this one!

Namaste 🧘‍♀️

Billy @ We Heart Excel