Used this Formula in D2 and drag down. .
=SUBSTITUTE(A2," ","")
Cheers
On Nov 16, 2014 9:32 AM, "Imran Khan" wrote:
> To All:-
>
> PLease help me to provide formula to eliminate the space. Example file
> attached.
>
> Regards,
>
> *Imran Khan*
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Hello,
Awaiting for your reply.
...yudy
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles
To All:-
PLease help me to provide formula to eliminate the space. Example file
attached.
Regards,
*Imran Khan*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Hi Vabz,
i have done part of it and i need some amendments alone.
1) Macro for BG:
It works fine. But there should be an additional condition.
I won’t be able to explain it, but I will try to represent it on this
picture.
On this picture below all the lines should be OK, because there is also
Can you explain it bit more with one example & sample of 9 to 10 lines
only...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Nov 12, 2014 at 4:52 PM, Laxmanan M wrote:
> Thanks vabz,
>
> How to achieve the second macro using vba.I tried here but a
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 15, 2014 at 8:42 PM, Ashish Kumar
wrote:
> Hi Vaibhav Bhai,
>
> It's GREAT!!! Fantastic :)
>
> Regards
> Ashish
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’
Hi Vaibhav Bhai,
It's GREAT!!! Fantastic :)
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
Hey Eugene,
Check this...
Pres alt + tab twice to type data in sheet & will send form in background...
When form is in background, press Ctr + Shft + U to close floating image...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 15, 2014 at 7:05
Hi
You can add floating form with image!!
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 15, 2014 at 10:50 AM, Eugene Bernard
wrote:
> Thanks, I am, temporarily doing by this mehod only.
> regards
> Eugene
>
> On Sat, Nov 15, 2014 at 9:49 AM, M
Hi
It uses VBA dictionary object, and good feature of it is that it does nit
add duplicated record in it.!!
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 15, 2014 at 2:23 PM, Mandeep Baluja
wrote:
>
> May I know how duplicates are removing ??
Thank you all. It's really helped me a lot.
Thanks in once again
On Thu, Nov 13, 2014 at 6:24 PM, Mandeep Baluja
wrote:
> Hey Kalyan,
>
> check this array formula and the
> sheet.
> =COUNT(C4:R4)-COUNTIF(C4:R4,"<=0")-SUM(IF(ISNUMBER(SEARCH(".",C4:R4)),1,0))
>
> Regards,
> Mandeep Baluja
>
> On
Welcome Eugene.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Pl
May I know how duplicates are removing ?? as you have not wrote any command
but still duplicates removed in this code. Vabz.. How ?
Thanks in advance
Mandeep
Sub GetUniques()
Dim d As Object, c As Variant, i As Long, lr As Long
Set d = CreateObject("Scripting.Dictionary")
lr = Cells(Rows.Coun
13 matches
Mail list logo