separate cell data

Hi Gurus, Can you share your idea on how to automate this? I have below data usually long set. Account Country Score Date 1 France 1000 09/30/2021 2 Norway 500 05/31/2019 I wanted to separate and add 2 blank cells if the date is more than 1 year. Let's say macro will ask for...

Hi, I am new in the ways of VBA coding, and I have been mostly adapting recorded code. The most that I can do is to define variables, make relative references and simple loops xD I am working with catalogs for cars and car parts. For one particular distributor, the only way of obtaining the full...

Hi Guys, Can you possibly help me of how to code for this scenario: Basically, I need to exclude the data not older than 4 years. However for the computation, the start date is not based from the current date but I want to set the date so a message box will pop asking me what is the starting...

Hi All, I have to create multiple dashboards for a client and I'm looking to streamline our process. One of the tabs used in the dashboard is a summary of costs based on multiple criteria. Right now it is set up that each entity the client is looking to analyze has their own tab however I'm...

<tbody> NAYASARAK, CUTTACK, DISTRICT CUTTACK, ORISSA-753002 <tbody> BAGHTHALA, BLOCK, TAHSIL - BAWAL, DISTRICT - REWARI, PIN - 123501, HARYANA <tbody> 947,10TH 'D' ROAD, SARDARPURA, JODHPUR - 342001 <tbody> PIN 123504, NOORGARH CHOWK, HAILY MANDI, PALHAWAS ROAD, NOORGARH, i have...

Greetings! I have a column in a spreadsheet with cells each custom formatted to display a number (indicating quantity) and a unit of measure (such as lb., kg, can, pc, etc.). I need to separate this column into two formatted as number and text displaying the numeric value for the quantity and...

In column A, I have cells with text and numbers (example: abc12446, xyz14456, etc.). I want to separate these into column B cell with abc, and another column with 12446 in it. How do I do this?

Hello, just recently joined and this is my first post. The problem I have is this: A cell would contain several formats like... "KAT LI 927000000403G LINS" and I need to extract "927000000403G" "KAT LI AA432IPXTV00HB (LINS) Alt 2" and need "AA432IPXTV00HB" "KAT LI ICE-8S10 (LINS)" and need...

Hi, I am using Excel 2007 in windows 7 I would like to delete values within a cell which are separated by semicolon. Eg <colgroup><col><col></colgroup><tbody> <colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col...

Hello, I have the following situation. I have a column of cells that have the first part of the cell (ID number) separated by a dash but occasionally within the latter part of the cell there exist other dashes in the description. I was wondering how to get the description part that is just...

<tbody> Expense Food drinks 1. Food Bread Bread Rice Rice Drink Water Water 2 drink Juice Juice Food Pasta Pasta 3 foOd Meat Meat Drinks Coffee Coffee </tbody> HI, I hope you could help. i have 1 column and it...

I would like some assistance creating two separate “user defined functions” whereby when I select the data, it separates the data to either number or text. I’ve included the format that the data will normally be in. Also please note that i'm requesting a function and not a macro so that for...

I have an order number such as 012, 013 in a separate sheet with details like <colgroup><col><col><col></colgroup><tbody> Order No 012 Status UserName Action Process Tom Await Approval Process Richard Await Approval Process Swetha Await Approval Process Michael Rejected Process...

Hi all, I was wondering if there was a formula so that I could convert the following into the desired format. <colgroup><col></colgroup><tbody> 12 mins 52 secs = 12.52 4 mins 11 secs = 4.11 23 mins 35 secs = 23.35 2 mins 39 secs =2.39 29 secs =0.29 22 mins 33 secs =22.33...

I want to write an if statement or VBA to separate the day, month and year. Instead of reading 1/12/2010 I want the 1 to appear in one column the 12 to appear in another column and the 2010 to appear in a separate column. One of my concerns is the first number can sometimes be two digits and...

I have an excel sheet that I need to separate out. I've already got the city/state issue solved, but I have a "name" cell that contains varying data ie) a1= Dr Joe Smith a2= dr and mrs john adams a3= mr greg j. Johnson I need to separate it out as simply as possible....any suggestions? I have...

I am creating a database in Excel 2010, where we have many job positions that need to be filled. I would like to have a column that lists the positions that are required and a column beside it that will have a formula, which will say the word "Filled" in it if one cell contains the word "PM"...

Hi, I have downloaded the data in the table, and it came with the percent numbers (in grey) stuck to the volume numbers (in black). I have 400 rows like this and need two columns - one for volume numbers and the other for percent numbers. Because I have various numbers of characters in each row...

Hello, I am trying to find a solution for what I think is a challenging problem. I have a large file with cells filled with text (converted from a database, imported into Excel). The text is in rows of column A and always contains a 16 digit number, which is what I need. I am able to clean up...

I have data in this format <TBODY> Item # Data A 1, 2, 3, 4, 5 </TBODY> And I am trying to see if there is a way to separate the data column into separate colums anywhere that a comma is present.Need data to look like this. <TBODY> Item # Data Data Data Data Data A 1 2 3 4 5 </TBODY> Any...