Skip to content
  • Standard
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
XLf(x)s
XLf(x)s
Excel functions and formulas
  • Standard
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
Category: <span>Texts and Strings</span>

Category: Texts and Strings

Home Standard functions Archive for category "Texts and Strings"

Jan8 date format

Jan8 date format
ANmar AND / Date and Time / Formulas - combined functions / IF / Logical / Standard functions / TEXT / Texts and Strings / TODAY  AND / IF / TEXT / TODAY April 24, 2023 April 24, 2023

Format a date in shortest format possible indicating how many days have passed (Past date) If date1-date2 < 8 Sat, Fri, …If date1-date2 < 350 Dec24, Jan4, Aug14Else 2020Feb4

Full article"Jan8 date format"

6174 Kaprekar’s constant

6174 Kaprekar’s constant
ANmar Basic Math / Formulas - combined functions / Standard functions / TEXT / Texts and Strings / VALUE  6174 / TEXT / VALUE September 2, 2022 August 18, 2022

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads walk you 6174

Full article"6174 Kaprekar’s constant"

Cuts string of list of items

Cuts string of list of items
ANmar Formulas - combined functions / LEFT / MID / SEARCH / Standard functions / Texts and Strings  LEFT / MID / Search August 17, 2022 August 17, 2022

An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using …

Full article"Cuts string of list of items"

Cells with additional spaces

Cells with additional spaces
ANmar AND / IF / LEFT / Len / Logical / Standard functions / Texts and Strings August 4, 2022 July 24, 2022

Detect which cells has additional spaces added by mistake by user. =IF(AND(Left(F2, 2) = “No”, LEN(F2) >2, “Space at end”, “”)

Full article"Cells with additional spaces"

Always get 1st name (or last)

Always get 1st name (or last)
ANmar Formulas - combined functions / IF / ISERROR / LEFT / Len / Logical / RIGHT / SEARCH / Standard functions / Texts and Strings / TRIM  IF / ISERROR / LEFT / LEN / RIGHT / Search / TRIM July 23, 2022 July 19, 2022

Formula to get first name from 2 formats either (Lastname, First) or (Firstname Last) formats.

Full article"Always get 1st name (or last)"

VALUE() of LEFT()

VALUE() of LEFT()
ANmar Formulas - combined functions / IF / IFERROR / Information / LEFT / Logical / N / Standard functions / Texts and Strings / VALUE  IF / LEFT / N / Number. / VALUE July 7, 2022 July 7, 2022

I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes not, others VALUE() worked, but …

Full article"VALUE() of LEFT()"

DayName

DayName
ANmar Date and Time / Standard functions / TEXT / Texts and Strings January 25, 2019 January 22, 2019

Simplest way to get name of day as cell output from a date. Because you can custom format a cell with date to show only that day name This is …

Full article"DayName"

Posts navigation

1 2 3 4
ANmar Amdeen

AND bug cell CHOOSE Column compare CountIF DATE dynamic EU Excel2010 Excel2013 format golast google googletranslate IF INDIRECT INT LEFT LEN link MATCH Math MAX MIN N Non-Functions Number. OFFSET RIGHT Schedule Search shape shapes SUM TEXT TODAY translate TRIM underline US VALUE VLOOKUP WEEKDAY

  • October 2023 (1)
  • May 2023 (1)
  • April 2023 (2)
  • January 2023 (2)
  • November 2022 (1)
  • October 2022 (1)
  • September 2022 (3)
  • August 2022 (6)
  • July 2022 (9)
  • October 2020 (2)
  • September 2020 (1)
  • July 2020 (1)
  • March 2020 (1)
  • February 2020 (5)
  • August 2019 (1)
  • April 2019 (1)
  • January 2019 (6)
  • December 2018 (7)
  • October 2018 (1)
  • August 2018 (1)
  • April 2018 (2)
  • March 2018 (6)
  • February 2018 (2)
  • December 2017 (3)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (2)
  • December 2016 (1)
  • September 2016 (3)
  • November 2015 (1)
  • September 2015 (1)
  • May 2015 (1)
  • April 2015 (2)
  • June 2014 (1)
  • March 2012 (1)
  • February 2012 (14)
  • January 2012 (10)
Log in
Powered by Kahuna & WordPress.
©2018 XLf(x)s=Excel Functions | ANmar.Systems
Back to Top