Tag: LEFT

Middle name + 1st name

February 3, 2024 ANmar

Get the initial (middle name) from a triple name in a cell.
C4 The cell contains the triple name separated with spaces.
=LEFT(C4,1) & "." & MID(C4, SEARCH(" ", C4, 1) + 1, 1) & "." & MID(C4, SEARCH(" ", C4, SEARCH(" ", C4, 1) + 1) + 1, 1) & "."

Read More “Middle name + 1st name” »

Basic Math, Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

Cuts string of list of items

August 17, 2022 ANmar

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 formulas only.

Formulas - combined functions, LEFT, MID, SEARCH, Standard functions, Texts and Strings

Always get 1st name (or last)

July 23, 2022 ANmar

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

Formulas - combined functions, IF, ISERROR, LEFT, Len, Logical, RIGHT, SEARCH, Standard functions, Texts and Strings, TRIM

VALUE() of LEFT()

July 7, 2022 ANmar

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 I did not see a function-does-all solution.