RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-11 Thread Mohammed Muneer
ifferent columns use Text To Column Delimited by Space character , See the attached file. Thanks Priti Verma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 11 July 2012 10:20 To: excel-macros@googlegroups.com Subject: RE

RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-11 Thread Priti_Verma
[mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 11 July 2012 10:20 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Extracting a word from the cell... Dear Rajan & Priti Verma, Any one word, left / right / middle. Thanx both of u, for t

RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Mohammed Muneer
u want the first word in a string then =LEFT(D10,FIND(" ",D10)) or Sub fw() For i = 2 To Cells(Rows.Count, 2).End(xlUp).Row Cells(i, "c").Value = Left(Cells(i, "d"), InStr(1, Cells(i, "d"), " ")) Next i End Sub Don Guillett Microsoft

Re: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Deba Ranjan
_ >> >> ** ** >> >> If you are saying you want the first word in a string then >> >> =LEFT(D10,FIND(" ",D10)) >> >> or >> >> **** >> >> Sub fw() >> >> For i = 2 To Cells(Rows.Co

RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Mohammed Muneer
ehalf Of Mohammed Muneer Sent: 10 July 2012 7:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment. Regards,

Re: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Abdulgani Shaikh
Up).Row > > Cells(i, "c").Value = Left(Cells(i, "d"), InStr(1, Cells(i, "d"), " "))*** > * > > Next i > > End Sub > > > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmai

RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Priti_Verma
$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment... Regards, Muneer, CC.. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate

RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Mohammed Muneer
lle...@gmail.com From: Mohammed Muneer <mailto:mmun...@ccc.com.qa> Sent: Tuesday, July 10, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group, I want to extract a word from the sente

RE: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Rajan_Verma
Which word you want to extract? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: 10 July 2012 7:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word

Re: $$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread dguillett1
icrosoft Excel Developer SalesAid Software dguille...@gmail.com From: Mohammed Muneer Sent: Tuesday, July 10, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Extracting a word from the cell... Hi! Everybody, Dear Group,

$$Excel-Macros$$ Extracting a word from the cell.......

2012-07-10 Thread Mohammed Muneer
Hi! Everybody, Dear Group, I want to extract a word from the sentence in cell beside. Plz, find the attachment. Regards, Muneer, CC -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik