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$$ Can cursor will go to cell "D1" when we press enter

May be this will work for you. Thanks shekar. It was very helpful to me. On Sunday, 4 November 2012 05:51:21 UTC+5:30, shekar wrote: > > edit a cell and press enter > > > On 3 November 2012 22:10, Rohan Young >wrote: > >> hi raja, >> >> its not working >> >> regds >> >> >> >> On Sat, Nov 3, 2

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

edit a cell and press enter On 3 November 2012 22:10, Rohan Young wrote: > hi raja, > > its not working > > regds > > > > On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR wrote: > >> >> >> >> On 3 November 2012 15:44, Pravin Gunjal wrote: >> >>> *Thanks Kuldeep for your reply.* >>> *I want the

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

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

hi raja, its not working regds On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR wrote: > > > > On 3 November 2012 15:44, Pravin Gunjal wrote: > >> *Thanks Kuldeep for your reply.* >> *I want the cursor should go in the cell "D1" when the ENTER key is >> pressed.* >> * >> * >> On Sat, Nov 3, 201

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

On 3 November 2012 15:44, Pravin Gunjal wrote: > *Thanks Kuldeep for your reply.* > *I want the cursor should go in the cell "D1" when the ENTER key is > pressed.* > * > * > On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh wrote: > >> >> Hi Pravin, >> >> You want to press enter --> D1,D2,D3 OR, D1,

Re: $$Excel-Macros$$ Want to get your question answered quickly?

Somnath, Can you please create your own post for your query. This is violation of forum rules and you will be banned on repeating this action. -Ayush On Saturday, 3 November 2012 20:28:26 UTC+5:30, Somnath Khadilkar wrote: > > Dear SIrs, >I have an XL file with few sheets [ DATANov01] > O

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

hi, Click the mouse in the Name Box (the area to the left of the formula bar that shows an address of present or selected cell(s)) press D1 and enter. redgs On Sat, Nov 3, 2012 at 3:44 PM, Pravin Gunjal wrote: > *Thanks Kuldeep for your reply.* > *I want the cursor should go in the cell "D1"

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

*Thanks Kuldeep for your reply.* *I want the cursor should go in the cell "D1" when the ENTER key is pressed. * * * On Sat, Nov 3, 2012 at 3:35 PM, Kuldeep Singh wrote: > > Hi Pravin, > > You want to press enter --> D1,D2,D3 OR, D1,E1,F1,G1 > > Regads, > Kuldeep Singh > > On Sat, Nov 3, 2012 at 3:

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

Hi Pravin, You want to press enter --> D1,D2,D3 OR, D1,E1,F1,G1 Regads, Kuldeep Singh On Sat, Nov 3, 2012 at 3:32 PM, Pravin Gunjal wrote: > *Dear Friends,* > * > * > *Is it possible to move the cursor automatically in to the cell "D1" when > we hit the ENTER key.* > *Please inform.. Thank you

$$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

*Dear Friends,* * * *Is it possible to move the cursor automatically in to the cell "D1" when we hit the ENTER key.* *Please inform.. Thank you.* * * *Regards* *Pravin Gunjal* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members alr

$$Excel-Macros$$ Want to get your question answered quickly?

Dear members, If you keep below points in mind while asking your query, The chances to get answered is just high : 1. *Ensure your question is not too vague.* Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body