[ExcelVBA] Re: Combining cell results in different worksheets

 

Finally finished my project and all came out well with calculations and formating. Now to read up on protection and it will be wrapped up.
Thanks to everyone that helped. Much appreciated. G.

--- In ExcelVBA@yahoogroups.com, "Hafizullah" <hafizullah@...> wrote:
>
> If you want ALL spaces removed:
> Replace(Range("a1").Text, Chr(32), "")
>
> will get you
> 27196339215235
>
>
>
>
>
> Hafizullah
> @}->-`-,---
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Members 4
• New Files 1

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___