carriage return

  1. S

    Carriage Returns in Headings but if used in Range wont find

    If I enter carriage returns of Chr(10) in a cell, I cant seem to select the cell heading in the code below unless i take out the Chr(10) code. Is there a trick to this please? ' Extra Headings .Cells(row, col + 1).FormulaR1C1 = "Calc" & Chr(10) & "Eval Date" '...
  2. H

    input box, auto enter

    Hi there, Is there a way to have an automatic carriage return once a limit is reached for an input box? Ex. Once 8 characters have been entered in the input box, there is an automatic carriage return, thus hitting OK. This is to be used for scanning barcodes and would simplify the process...
  3. R

    Carriage Return characters removing - Interesting case

    Hello, We have an excel spreadsheet which users fill out and send it to us. We convert that in a CSV file and then send it to Oracle for uploading. In excel file , we observed that there were some carriage return characters which would create issues while loading the data in oracle tables. so...
  4. L

    Carriage Returns in a Cell - what character?

    Hi there I was looking for a way to paste data from Word into Excel, and found several posts on the topic (e.g. http://www.mrexcel.com/forum/showthread.php?t=337939 or http://www.mrexcel.com/forum/showthread.php?t=221306). However, I didn't find any explanation on what the ASCII character...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top