The Trumps' wedding ceremony and reception were widely covered by the media. Trump wore a $200,000 dress made by John Galliano of the house of Christian Dior. In 2006, Melania gave birth to a son named Barron William Trump. Donald suggested his first name and Melania his middle name. As an infant, Barron reportedly occupied his own floor in the Trumps' apartment in Trump Tower in Manhattan, but often slept in a crib in his parents' bedroom.
Method 1: Convert month name to number with formula. Type this formula =MONTH(DATEVALUE(A1& 1)) ( A1 indicates the cell that you want to convert the month name to number, you can change it as you need) into a blank cell, and press Enter key.
1 Select the Cell B2, write the formula = LEFT (A2, SEARCH (â â, A2)), function will return the first name from the cell A2. 2  To Copy the formula in all cells press the key âCTRL + Câ and select the cell B3 to B6 and press the key âCTRL + Vâ on your keyboard. Select the Cell C2, write the formula =MID(A2,SEARCH(â â,A2,1)+1,SEARCH(â â,A2,SEARCH(â â,A2,1)+1)-SEARCH(â â,A2,1)) it will return the middle name from the cell A2. 2  To Copy the formula in all cells press key âCTRL + Câ and select the cell C3 to C6 and press key âCTRL + Vâon your keyboard.