Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down

**scaruso1** · 08-14-2023, 07:27 PM

Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down. Easy way is to slit it in new rows but copy the assigned Colum beside it to each new row?

**TMS** · 08-14-2023, 07:44 PM

Try:

Formula:

Please Login or Register  to view this content.

**scaruso1** · 08-14-2023, 07:46 PM

Originally Posted by TMS

Try:

Formula:

Please Login or Register  to view this content.

Wow that is amazing, thank you so much, works like a charm!

**TMS** · 08-14-2023, 10:48 PM

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down

LinkBack

Thread Tools

Rate This Thread

Display

Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down

Re: Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down

Re: Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down

Re: Cannot xloopup a value in a cell that has CHAR(10) Breaks, How to break it down

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adjust CHAR(10) function - limit line breaks

Adding CHAR(10) to add line breaks causes speech marks to be added

NEED HELP WITH LINE BREAK CHAR(10) Function

Summing up figures in a SINGLE cell divided by alt-enter line-breaks (aka Char(10))

[SOLVED] Unable to get cell count when using line breaks char(10)

[SOLVED] Insert a line break (CHAR(10)) after every 42 characters

[SOLVED] Can I set an automatic page breaks to break every 40 lines?

Bookmarks

Bookmarks

Posting Permissions