carriage

Can someone as assist with a code that will enter a carriage (Enter) whenever the multi-line textbox wraps the string to the next line. I know the multi-line textbox will do this for me, but I need this to enter it a cell to indicate to separate line. Thanks for you

I have code that enters text in a footer, how do I force vba to enter a carriage return in the footer so the text is on more than 1 line?

Why Carriage Return or Line Break or ALT+Enter adding automatically in every excel cell ? is it a virus or corrupted excel software because I did not put anything its auto adding in every cell ? I have reinstall office 2013 many times and windows 7 also but same problem every time. please help...

I'm trying to remove only the trailing carriage returns from my data. Sometimes there's 1, sometimes 2 or more. I don't want to remove other line breaks, only the trailing ones. Can anyone kindly assist?

Right now I have code that creates a table in PowerPoint 3 rows x 2 columns. This is created from a worksheet in Excel, by copying a 2x3 range of cells. Within each cell are multiple lines of text. The problem I face is that the text in PowerPoint needs to be bulleted. I used the following...

Hello everybody. I have a range composed by cells with data separeted by ; for example 125; 545; 5498; 154 Now, inside the cells, I need carriage returns to turn the text into this way: 125 545 5498 154 My unsuccessful attempt: range.Replace what:=";", replacement:=vbNewLine...

I want to make macro to combine a group of data (separated by blank rows) from multiple cells in a column into one cell with carriage return (alt+enter) between each cell value. Can somebody help me with this. see below: <colgroup><col><col></colgroup><tbody>...

Hi there, trying to make a templating engine udf function to handle string replacement but I can't seem to figure out how to handle carriage returns. I want to insert a carriage return when my engine processes <cr> string. Here's my code. The red line is my attempt to do the carriage return...

Hi, any thoughts/solution son how I can have the date/time as indicated in code below. I would like same cell to display date top line, carriage return and time below date, all same cell. The following doesn't quite do it Cells(1, "A").Value = Format(Now(), "ddmmmyy & Chr(10)HH:mm ") thanks...

I thought this would be super easy-peasy. But man I am stuck. I have a Word table - that has formatted text (bold, italic, indents, bullets, and carriage returns inside the cell) that I need to preserve. I'd like to be able to put that inside a spreadsheet. But when I copy-and-paste, it...

Hi there, I have a workbook which is purely for user input ie. the user is just inputting data. Many of the cells are designed to hold large amounts of text (which are formatted to wrap text). However when many people type, they like to hit the {return} key to invoke a carriage return. Excel...

Hi, Had a macro that worked, they have now changed the data. I have a column that can contain a name with the following after the name , space, then (Team Member) ie George Smith (Team Member) The next cell may have up to 6 names, each with (Team Member); after each name Gary Wing (Team...

I built a spreadsheet for a coworker that takes data from a website and collates it into a nice sheet that's linked into a Powerpoint that is displayed at a weekly meeting. I have the sheet set up so that is uses index-match-match to pull specific values from an array on another sheet...

I am attempting to write to a txt file in excel from two separate ranges in 2 different sheets. Below is the code that works, but it leaves a carriage return at the end of the txt file that I cannot have when importing into our software. Could anyone be able to help a VBA beginner out with this...

Apologies if this has been answered before, I can find similar topics but not an exact solution I need to create a .csv file from data in an excel worksheet for use in another application. When the csv file is created there is always a final carriage return / blank line which requires manually...

Hi there everyone I've just converted a bunch of emails from an Outlook folder into Excel. All went well except for the field that is the body of the email is causing me an issue. In Excel, the converted field shows in the cell as e.g.: Name John Smith Company John Smith Limited Position...

Hello Everyone, I'm writing a Macro where I need to Import a CSV file as text where each line is not Delimited, but has a Fixed Width or is altogether. It also has to delete or not consider LF or CR that are between quotes before importing the data. So basically I'm trying to put every line in...

Hello, I have some code and I can't figure out how to continue it on a new line. I have to be able to do it somehow otherwise it's going to be a really long (horizontally) row. I've tried a bunch of combinations of " _ , "_, _, etc and nothing seems to work for some reason. Any help would be...

Hi, I have a merged cell - B61 (B61:H68) in which I want to type notes. I want to be able to hit enter and start a new line in the cell. I know Alt-Enter does this, but end-users of this spreadsheet will not know this trick. Is there VBA code I can use? Thanks in advance......:)