number and text

I have cells that contain multiple values as a full string: Apple - Banana - 000123 When I convert to three columns using the "text to columns" operation, the third column converts to a number and removes the leading zeros (cell value turns into 123 as a number). This is breaking my lookup...

I thank each and every Mr. Excel forum members who are helping hundreds of Productivity Issues daily. I am looking for a solution to remove similar duplicates by identifying the Pattern which every text ends with a Number. Based on Column A (primary key) - the macro should run on column B...

Hi there I would love some help in figuring out how to report subtotals from an existing dataset that has been created by combining values from two separate lists. List 1 - Category: Adoption, Process, People, Technology, Tools, and Location List 2 - Impact: 0 - No impact, 1 - Extremely Low...

Hi All, This is a similar question to another thread:https://www.mrexcel.com/forum/excel-questions/1081373-code-works-text-not-numbers.html I've tried the solution suggested on the thread but still isn't working for me. The column I am filtering on has numbers in text formats, such as "004"...

Hi, I was wondering if it is possible to use number formatting to do the preferred option below. I have a lot of codes and have to type the space between the text and numbers. Any help or ideas will be appreciated. <colgroup><col><col></colgroup><tbody> GENERAL PREFERRED DSF485EC DSF 485...

I have the following data: 15ab 12cc 6ll 9bc and i need to extract the number portion of the string. My text string will be either 3 or 4 characters long. If len=4, then left,2. If len=3, then left,1. I can't make the formula work in excel. Can someone please help?

Hi there, I have a sheet with a text field and a command button to do a search according to the text in the text field. Also I have a reset button. The issue is that when entering numbers or dates in the text field and execute a search, the macro goes to the end of the table without showing any...

Hi All, I hope anyone can help me with below request... I have data with filed called description and which consists of unique PO number and this line item not standard data, every line item which inclusive of special character different different numbers along with PO number. Example Data...

extract +/- numbers from alphabet cell %&AmK ! hi sir I'm doing some research, and I have excel sheet attached with 3 columns; cells are complex alphabet (%+-aKM&) with numbers (+-). FOR MY STUDY PURPOSES - i want to extract only the numbers value (be care that some numbers are +; others are...

Hi there, I have a list of part descriptions that I need to extract part numbers from. These part numbers may be purely numeric, alphanumeric, or contain hyphens, underscores or special characters: e.g. <tbody> Descriptions Part numbers Handle #09-ir2135ti #09-ir2135ti D90-330-EX...

Hi, So I have a list of data that looks somewhat like this ABC00004 ABC01085 ABC00334 ABC00100 I want it to look like this 4 1085 334 100 The ongoing theme is that there will always be 3 letters and then numbers after it. I want to capture the number only, and with no leading zeros, but I...

Hello, Im making an invoice and need some help! How can I create a formula that automatically calculates the 'Total' considering that the prices (Price 1 and Price 2) are in the same cell, separated by rows, and in a 'number/text' format (50EUR)? Also, how can this formula calculate new prices...

so ive tried using the formula To remove °C from 10 °C for example =LEFT(E10,LEN(E10)-SUM(LEN(E10)-LEN(SUBSTITUTE(E10,{"A","B","C","D","E","F","G","H"},"")))) In an attempt to remove it but i get 10.0 ° Theres still a degree remaining, how do i completely remove this?

<quote> I was curious if someone could tell me how to change this formula and add some properties. Such as: To ignore number strings lead by zeros, if an x is directly behind a + = - its counted as a 1 is extrated (or in the case of the - a -1), and if a - is directly in front of a number...

HI, I have a large number of rows with characters and numerals in it. They mostly (but not all) follow a similar combination to this: xxxx - 12 - xxxxxxxx or xxxx - 123 - 456 xxxxxxx or xxxx - 1234 - 56 xxxxxxxx I would like to pull out the first set of numbers only into a separate column...

Hi, I have to insert some rows to my existing spreadsheet. The rows are currently numbered in column A from 1 until 3000. I am adding rows to add a level of detail to some of the items numbered above. Because of this, I want the rows I add to use the number from the row above but add 'a' to the...

Hello, I used a UserForm to enter information into a few cells in Sheet1. On Sheet2, I have a column of codes (ie 23456; 25678; 12345MD; 15389MD). I am trying to compare one cell from sheet1 to the top cell in sheet2, and if it does not match, move down the column until it does. The BOLD is...

Hello Everyone: I am new to MrExcel.com forums and this is my first post here. I need to extract numbers from excel cells. For eg- <tbody> BAR TBG 04.00X02.25X26.50 1340 HRN SMLS SPEC. ES4.38694 ^^^ This is one of the cells. I need to pull out 04.00, 2.25, 26.50, 1340 into...

Hello :) I have a file with multiple sheets for each day of the month to track daily sales...each sale/order is given a unique reference number. This reference number includes the sales person's unique prefix (2 letters), followed by a consecutive 2 digit number - e.g. sales person's first...

Hi, I am hoping to use Data Validation to create a drop-down list from a dynamic column that contains a mix of text cells and number cells. To make it more complicated, the list needs basically every convenience feature known to man (or that I can think of): it needs to be dynamic...