Archive for April, 2017

MS SQL Replace Line Break

SELECT REPLACE(REPLACE(@str, CHAR(13), ''), CHAR(10), '')

No Comments

Find the first number’s position in a text string with formulas

Select a blank cell where you will return the first number’s position, and enter the formula =MIN(IF(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},A2)),FIND({1,2,3,4,5,6,7,8,9,0},A2))) (A2 is the text cell where you will look for the first number’s position) into it, and then drag its Fill Handle to the range as you need. See below screenshots:

No Comments