![]() ![]() So, using the SUBSTITUTE function, you can replace the line break with something like a comma or a The line break within a cell to make content appear on different lines is represented by CHAR(10). ![]() How To Separate Data In A Cell Based On Line Breaks, Convert text to columns in Excel when you have a cell that contains text semicolons, or some other delimiter and all you're trying to do is get The ASCII character code for a new line break is 10 for PCs and 13 for Macs. Excel text to columns line break delimiter
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |