Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

try this UDF. Check the attachment. Function con_2(irng As Range) Dim sirng, i As Long, out2 As String sirng = Split(irng, " ") For i = LBound(sirng) To UBound(sirng) out2 = out2 & Left(sirng(i), 2) & " " Next con_2 = out2 End Function On Sun, Nov 4, 2012 at 12:40

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

Hi, What if A1 hold more than 3 values? example: "Bill William Gate Junior" I would like the formula to take in consideration any number of values example: "Name1 Name2 Name3 Name4 Name(n)" Thanks > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

Hi, please find attachment. *Best Regards,* *Ms Excel User* On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote: > Hi, > > The text is located in a single cell and it can be of variable words... > > example: > > Cells A1: "John Doe Junior" > Cell B1 should return "jodoju" > > or > > Cell

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

ok then use LEFT($B$12,2)&LEFT($C$12,2)&LEFT($D1$2,2) On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote: > Hi, > > The text is located in a single cell and it can be of variable words... > > example: > > Cells A1: "John Doe Junior" > Cell B1 should return "jodoju" > > or > > Cell A1: "John Doe"

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

Hi, The text is located in a single cell and it can be of variable words... example: Cells A1: "John Doe Junior" Cell B1 should return "jodoju" or Cell A1: "John Doe" Cell B1 returns "jodo" Thanks > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORU

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

plz put range as per ur requirement On Sat, Nov 3, 2012 at 11:24 PM, Rohan Young wrote: > HI, > > TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2) > > REGDS > > > On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote: > >> Hi, >> >> Is there a formula that would the 2 first characters from a name, eg

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

HI, TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2) REGDS On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote: > Hi, > > Is there a formula that would the 2 first characters from a name, eg. > first, and/or second, and last name? > > example: > in cell A1: > "John Doe Junior" > in cell B1 the formu

$$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

Hi, Is there a formula that would the 2 first characters from a name, eg. first, and/or second, and last name? example: in cell A1: "John Doe Junior" in cell B1 the formula would render: jodoju or if "John Doe" jodo Thanks -- Join official facebook page of this forum @ https://www.facebook