Convert a formula text to a working formula without vba [SOLVED]
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 …
Convert text to hex [SOLVED] - Excel Help Forum
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 …
Converting text based fractions to numerical values [SOLVED]
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 …
Convert Text date with 3 character month name and 2 digit year …
Jul 10, 2019 · The issue I'm having is converting imported text in the format "Jul-21" to a date format excel recognizes as the 1st date of the month from the given text. For example, "Jul-21" …
Cells won't convert to number format, even after format/cells/num.
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?
Convert rows into 1 cell or 1 string - Excel Help Forum
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 - …
Cannot convert text to date [SOLVED] - Excel Help Forum
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 …
Convert Text to to Short Date [SOLVED] - Excel Help Forum
Feb 16, 2023 · Convert Text to to Short Date I have a spreadsheet full of long dates formatted as text (i.e. January 1, 2023). I changed the cell format to short date (01/01/2023). But it only …
[SOLVED] Looking for a formula to convert American ... - Excel …
Feb 21, 2017 · Forum Microsoft Office Application Help - Excel Help forum Excel Formulas & Functions [SOLVED] Looking for a formula to convert American dates to British dates. The use …
Convert Text Range in cell to count number of Cells [SOLVED]
Jul 29, 2025 · I have a cell with a rectangular text range written D17:G66. I would like to count the number of cells in this rectangular range. What formula should I use to calculate that number …