numbers & text

Hello, I am attempting to extract data from a string. I have employees copying tabular data out of another software. The software got updated, so now copied data only gets pasted as a string in one cell. I was hoping someone is able to assist with a VBA code or a formula to extract any numbers...

Hi all! Despite searching for similar posts, I have not found a solution to the following problem regarding a single cell with a very long string of multiple numbers and text. Here is a part of it: 118 A&E 131 AMC 184 Animal Planet.... How can I extract this string into rows with two columns...

Good afternoon everyone! I've got a weird one that I can't find anything for, nothing to even read up on so hoping one of you wizards can help! I'm simply wanting to make a dependent dropdown list where a date is chosen in one cell, then in the next cell a series of (numerical) values will be...

Hi. I have this database and the first column its the subjects # The original data goes something like this: 1 1 2 2 2 3 3 3 4 4 Id like to turn it into something like this: 1a 1b 2a 2b 2c 3a 3b 3c 4a 4b Any tips?

Hi, I have a list of trading volumes that are given as a mix of numbers and letters, i.e. 1.46M, 856.56K. I'm trying to convert the list into the numbers by transforming the 1.46M into 14600000 and 856.56K into 856560, but I've as yet been unsuccessful. Any help would be great.

I need to convert commentaries in excel on financial data from dollars to euros every month. Rather than manually calculating and converting the numbers and changing the $ sign to €, is it possible to write a macro that extracts numbers from a text string, multiply the numbers by an exchange...

Hi all, i 'm looking for solution to the following problem: i have a string at B1 and C1 columns like this: <tbody> bread 1 item 330 calories apple sugar 300g 1232 calories tost 110g 250 calories </tbody> etc... All i want is text extraction like: D1 column E1...

Hi All, I'm sure this is a common theme on this board, but numbers appearing as text is causing me a helluva problem. I'm running an awkwardly complicated series of if statements with vlookups matching property codes in the first column and returning data from second column (see sample data...

Hi all, after searching all through the forums and posts I could not find a solution to the following problem: I have 2 columns ,A and B, in a table and text strings in C. Each table row A1 and B1 needs to be compared and matched with the text string C:C. Only if both, A1 and B1, are found in...

Dear All, I have data in the following format in column A. Input looks like- row 1-Scottish Widows Investment Management Ltd 3,602,689 3.36 row 2-Banco Santander Central Hispano S.A. 9.62 Column A is a mixture of name(Scottish Widows Investment Management Ltd) and...

Hi Guys, I nearly have my Macro finished stuck on one thing. I want to make Cell A4 my Sheet Name. Cell A4 contains both Letters and Numbers Cell A4 may start with a word eg 'property: 165666' I Just was the Number 165666 as my sheet name. Also After the property number I want the Letters...

Good day all, I'm currently struggling with this conundrum...I need to transfer a figure from the end of a Row based on two criteria, column J= "1" & column O="Manufacturing, all this info being in a separate sheet, so far I have two formula's...both returning an incorrect result...