Dec 1, 2005 · Convert text one of the resultant columns into hex data which can then be converted to decimal - easy NOT ( apparently ) The hex to decimal bit is easy but I can't find out how to convert …

Sep 1, 2023 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Convert a formula text to a working formula without vba The use of AI tools (e.g. …

Aug 28, 2018 · Converting text based fractions to numerical values I have a spreadsheet with text based fraction values. I would like to convert these fractions into decimals in an adjacent column. Basically, …

Sep 6, 2005 · If I have a worksheet with 10 rows going down, how can I join all of them into 1 cell. Ex) 123 - aaa; 354 - ghg; 246 - hbf; 234 - ggd; I want the above 4 to fit into one cell like 123 - aaa; 354 - …

Jul 16, 2012 · Hi there please help I need to convert concatenated data from one cell into plain text within another cell.

Jun 10, 2005 · Hi Mike, In a helper cell enter the number 1. Copy that cell and then paste special/multiply into the cells you want to convert. HTH ray "Mike" wrote: > When I have a lot of data …

Apr 12, 2005 · In excel, I tried to convert numbers to number format, using format/cells/number from the category list. But it won't take, and stays text-like. Any ideas?

Oct 23, 2013 · Cannot convert text to date I have dates in a spreadsheet but some are text and some are number. Simply put, I need them to be all the same, which ever is easier to convert to date the …

Jun 5, 2012 · I have a concatenate formula that pulls from a few different cells, then I sort by the column that formula is in. The problem is that one of the cells pulled from contains numbers from 1-16. …

Apr 24, 2023 · Re: Convert text m/d/yyyy hh:mm:ss to date dd/mm/yyyy hh:mm Please read the yellow banner at the top of this page and attach a good sample file. If I take what you wrote above and copy …