Ms-Exl-Learner .
Sent: Mar/Thu/2012 11:13
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Split text in cell
Another Approach
Copy and paste the below formula in 2nd Row of any cell other than A2 cell
and drag it below.
=IF((LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ","&
Another Approach
Copy and paste the below formula in 2nd Row of any cell other than A2 cell
and drag it below.
=IF((LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ","")))>1,
TRIM(MID(TRIM(A2),
FIND(" ",TRIM(A2))+1,
(FIND("^",SUBSTITUTE(TRIM(A2),"
","^",(LEN(TRIM(A2))-LEN(SUBSTITU
Macro looks for 1st space and last space and gets what is between.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: L.K. Modi
Sent: Wednesday, March 21, 2012 11:23 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Split text in cell
Dear All,
Its
MVP Excel
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* NRao Mynampati
>> *Sent:* Wednesday, March 21, 2012 4:00 AM
>> *To:* excel-macros@googlegroups.com
>> *Cc:* Dilip Pandey
>> *Subject:* $$Excel-Macros$$ Split text in cell
>>
le...@gmail.com
>
> *From:* NRao Mynampati
> *Sent:* Wednesday, March 21, 2012 4:00 AM
> *To:* excel-macros@googlegroups.com
> *Cc:* Dilip Pandey
> *Subject:* $$Excel-Macros$$ Split text in cell
>
> Hi Team,
>
> How to remove a words left text and right text of r
tt
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: NRao Mynampati
Sent: Wednesday, March 21, 2012 4:00 AM
To: excel-macros@googlegroups.com
Cc: Dilip Pandey
Subject: $$Excel-Macros$$ Split text in cell
Hi Team,
How to remove a words left text and right text of reference
Ple
Hi Team,
How to remove a words left text and right text of reference
Please refer attachment.
Thanks in advance.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code