split cell contents

I am desperately hoping someone can help me, as I've repeatedly run into a wall for about two weeks now trying to solve this problem and I've finally admitted to myself that a solution is beyond my scope of knowledge. I should note I'm working in Excel 2010. I have an InfoPath form that submits...

Hi all, Got a sticky situation that is stressing me out, so need expert help!! I need to change the cell contents in reverse order - kind of sorting the cell Z-A but by line. I want to reverse the cell layout so that the latest comment is at the top. ie Comment 5 followed by 4,3,2,1 (the...

Here's the problem: I have a large spreadsheet filled with data across columns A:J. Each cell in each column contains a single value, EXCEPT columns F:H, which contain delimited data. I need to split these cells into multiple rows so that each row in the spreadsheet is unique and each cell has...

Hello Everyone! I got a question to split/copy specific rows of a list to a new sheet. I have try'd searching here on the forums but i coudnt find anything comming close to it. In the sheet they will put an X in a cell with above the numbers 5, 6 or 7. Then the list needs to be copy'd to a new...

Dear all I have a problem in splitting the data : 2-890 3-457 4-464 5-348 Jan - 99 4-567 4-576 Feb - 00 and goes on i used text to columns to split and show 2 & 890 in separate columns but it also shows some months , which is an error , i just want to show 99 in those cells, & remove the...

I have an output that puts multiple names into one cell. The names are in the format "LASTNAME, FIRSTNAME, LASTNAME2, FIRSTNAME2...) I need to split the names up and with first and last name separated by a comma, I can't use the delimiter as a comma. How can I approach this? Any help is...

Hi All, Issue: I am having issues with the following code to reach the desired outcome. I have had only some success with it in what I want it to do; Maybe I have misunderstood something :eeek: Dim LR As Long, i As Long, X As Variant LR = Range("H" & Rows.Count).End(xlUp).Row For i = 1 To LR...

Hi, I am trying to execute a script I copied from this site to transpose a column of values into unique rows. There was a very similar thread to my question, but the code does not work for my situation as I am a newbie to VBA. The referenced thread was...

Hi all. First time here. Have a question and haven't been able to find an answer yet in a few hours of searching, so here I am. I am running MS Excel 2003. A user inputs a string of letters/symbols all meaning different things. These would typically for my case be L, R, +, -, F. These...

Hi I have been trying to sovle this for a day now, and its frustated me. I have data in a column (Name) and dependant on where the data is in the string and the number of characters, depends on what column it should sit in. I have pasted a table below showing the possible combinations and how...

Hi guys! Well, although I am not very new to excel there are some master tricks that still I don't know. Because of that please tell me step by step like you are explaining to an idiot! I have a "D" column starts from 5th row and goes up to 165th row. Every cell in this column contains both...

Hi there, I'm not very successfully trying to split out values from one cell into two. I've read up a little on LEFT/RIGHT but my problem is that there isn't a uniform structure every time. Easier if I give you an example: The column contains details of a promotion eg "buy 2 for £25" or "3...

Good day to you all, and thank you in advance. I am running Excel 2003, having severe difficulty performing what feels like it should be a very simple macro. I have cells from Column A through M, and the text in column A has multiple data points of various character lengths from 2 to 8...

Hi, I am currently importing information from outlook into a single excel cell. The content of the email looks like the following - -------------------------------------------- REGISTRATION INFO -------------------------------------------- John Doe 123 Excel St. New York, NY USA 12345 123...