split cell

Hi I have a report which exports the date and time in one cell (column A). I would like to be able to split these via a macro into two cells and then change the date value so it is recognised as a date. Currently the date is delimited by dots and not recognised by Excel. I would like the date...

My first post please, be patient with me. I searched the posts and found this article helpful but it doesn't offer a complete solution. https://www.mrexcel.com/forum/excel-questions/1000593-vba-remove-specific-text-cells-within-column.html. I have 160,000+ rows in column C containing a URI...

Hi, I have cell which contains C45-C90, I want it to split into multiple rows and fill in the form C45, C46,C47...C90 For example: <tbody> colA ColB C45-C50 0.6 C99-C101 0.5 </tbody> Expected Result <tbody> Col A Col B Col C C45 C45-C50 0.6 C46 0.6 C47 0.6 C48 0.6...

Hello, I have a cell that contains various number of text separated by commas. I would like for the information separated by commas to go into a list below the first item in the cell. Here is an example. Current Data <tbody> ID Number First Name Last Name Involvement 58475 Kate Smith Law...

I need help with a Macro. I have a column data. Each Cell in the column has an IPv4 address and an IPv6 address. I only want the IPv4 address. What is the best way to leave the IPv4 address in this column? B1 & B2 have the original information. I need the data to look like B3 & B4...

Hello everyone, I need to write a macro in VB that separates data in one cell (which may contain numbers separated by commas and dashes) into individual cells in a column. I believe the cells are formatted as text if that makes a difference. A code within a for loop would be preferable since it...

Hello, I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell. I can do that by using Left and Mid function which I did and it works fine but I don't want...

Hello, Can somebody please help me in finding out the answer of the below problem : I have a large text in one cell (2000 to 5000 characters). There are small sentences in this text each separated by a comma (,). I want to split this text in 1000 characters in each separate cell. I can do...

Hi I am looking for advice on how to create the following macro. I have a spreadsheet of data that has columns A-Q. The column headings are always the same name. I am wanting the Macro to split the data in column G and create new worksheets that displays that data. The number of Rows of data...

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...

Hi, I have one column with 938 rows in Excel 2010. The vast majority(90%) of cells look like: " 2 B/W GGG". I want to use VBA to separate the "2", which is a quantity, "B/W", which is a type of cut, and "GGG", which is detail, and place these values in separate columns(2-4) as needed. The...

Column A has data e.g. cat is fat xy>zzy, dog is random xyzzy, rat is a hoax.set xyz, frog is alon.23e xyz, bullseye.8 x.z I have a look up table as below Col D xy>zzy xyz x.z (Note: the values in Col D do not have a set number of characters, so I cant use a Right/left Formula) I need...

I have a column in my spreadsheet called Model#. The format of these model numbers look like this: T Bold 5000.FX.B The dots are basically separators. I would like to copy over these model numbers to another column but remove the last dot and whatever that comes after it. For example: T...

I am using Excel 2010 on a Windows 7 Pro OS. I have developed a simple weekly schedule spreadsheet for use by our project managers to help allocate junior engineering resources. There are two different divisions within the company and I have simple macro buttons that will hide/show the...

I want to split a cell into two columns - without adding a column (since I have other sensitive data that will not allow me to add a column). Is there any way to split a cell into two cells/columns? Thanks M

Hi I am new to excel. I need a code for the following scenerio. In "Sheet_1", I am giving input as follows: A B C D E 1 Ram Chennai 10/03/1989 a/b/c First 2 Sam Mumbai 12/5/1980 d/e/f Second 3 Kumar Kolkatta 14/8/1999...

Hi all I have a worksheet in which certain cells have data in the following format: GROUP-ABCD-1.txt Is it possible to separate text like the above with "-" as the delimiter and then set a string as the text between the 2 "-". So if s is the string, then for the above example s would be...

Hi guys In a macro I'm working on, I wish to run a procedure if the first word in a cell in that column matches a certain word. For example the text in a cell in the column reads "Experiment 45 8" Where the numbers vary with each one. Currently I have written this: If Cell(a, 1).Value =...

Hi all As part of this ongoing macro project, I have to find the files of a similar name from the columns of file names that are present. The problem is that the files do not have the same names in each column. The first part (the project name) is the same then there is a - and some number.txt...

Hi I am looking for some help in how to split the follow addresses into two separate boxes. Example of current database. Lucas Heights 2234 Sylvania 2224 Barden Ridge 2234 I need Lucas Heights in one box and 2234 in another, any ideas of a macro? Regards, Rob.