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
[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
Wow! Superb here r the efforts.
Regards,
Muneer,
CC
Muneer Ji,
PFA.
For First Word:-
=IFERROR(LEFT(G2,FIND(" ",G2,1)),"G2")
For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND(" ",G2,1)),FIND("
",RIGHT(G2,LEN(G2)-FIND(" ",G2,1,"")
For third:-
=IFERROR(IF(LEN(C2&F2)+2>
Hi Shai,
For First Word:-
=IFERROR(LEFT(G2,FIND(" ",G2,1)),"G2")
For Second:-
=IFERROR(LEFT(RIGHT(G2,LEN(G2)-FIND(" ",G2,1)),FIND("
",RIGHT(G2,LEN(G2)-FIND(" ",G2,1,"")
For third:-
=IFERROR(IF(LEN(C2&F2)+2>=LEN(G2),””,MID(G2,LEN(C2)+7,LEN(G2)-LEN(C2&F2)-7)),"")
For Forth:-
=IFERROR(RIGHT(G2
Dear Rajan & Priti Verma,
Any one word, left / right / middle.
Thanx both of u, for the reply.
Like - Sweet, Sewage & Portable.
In order to filter my data easily.
Regards,
Muneer,
CC...
__
Which word you want to extract?
This is really great !
Suppose I want extract 2nd or 3rd or 4th word, then ?
Regards
On Wed, Jul 11, 2012 at 9:39 AM, Mohammed Muneer wrote:
> Dear Don,
>
> Superb & Innovative.
>
> Keep it up!
>
> Both code and formula good.
>
> ** **
>
> ** **
>
> *“Experience is the mother
Hi, Muneer , I want to ask u ,which word u want to extract , last or middle
Regards
Priti verma
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$$ Ex
Dear Don,
Superb & Innovative.
Keep it up!
Both code and formula good.
"Experience is the mother of Knowledge"
Whenever I receive a help from u people, in a fraction of seconds I feel
myself why I can't do this magic by myself.
But I keep trying to do some until I get an idea.
Bu
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
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.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 Excel Developer
SalesAid Software
dguille.
10 matches
Mail list logo
