| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I delete the end of line (result of shift-enter)
You're welcome, Kali - glad to help!
-- Regards, Jake Marx www.longhead.com Kali wrote: Thank you, Jake! It looks much better now. Kali. -----Original Message----- Hi Kali, You need to replace the vbCR (carriage returns) with empty strings when writing it to a cell: Sheets("Sheet1").Range("A1").Value = Replace$(txtTest.Text, vbCr, "") -- Regards, Jake Marx www.longhead.com Kali wrote: Hello there I have a form with multilined text boxes, in order to insert several lines I go "shift-enter", but when I save it, there is an extra character at the end of each line. I would really like to get rid of it. If you could help me, it would be great. Thanks! Kali . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ctrl+shift+enter | Excel Worksheet Functions | |||
| What is Ctrl + Shift + Enter ? | Excel Discussion (Misc queries) | |||
| How do I enter a formula that will delete a line when a cell = 0? | Excel Worksheet Functions | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| ctrl+shift+enter vs enter | Excel Discussion (Misc queries) | |||
![Jake Marx[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
