Microsoft SSIS and Sql Server Notes

Sunday, April 29, 2012

Working With Excel: Tips and Tricks

Replace Spaces with other characters : Use Substitute function

=SUBSTITUTE(G2," ","")

Posted by Bhavpreet Singh Narang at 11:03 PM

Labels: excel, microsoft, tips, tricks, working with excel

No comments:

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Labels

.Net (1) 12 Hours Format (2) 17058 (1) 2005 (3) 2008 (5) 2012 (1) 24 hour (2) 530 5.7.0 (1) Access is denied (1) Ajax (1) all database on a server (1) Alter Column Insight (1) Append (1) arabic to english (1) ASP.NET (1) assembly bind failure (1) avoid (1) Avoid Dynamic Query (1) avoid restoring database (1) awesome (1) back up notification (1) Backup restore (1) before inserting to db (1) Best Practices (1) bhavpreet (1) bhavpreet singh (1) bhavpreet singh narang (1) BIDS 2008 (1) Cannot generate SSPI co ntext (1) Certification (1) cgi proxy (2) characters (1) Clustered Index (1) code (1) collapse (1) collation (1) Combining Multiple Rows (1) command (1) Command Line (1) command prompt (1) Common table expression (1) company (2) Compare Databases (1) Conditional Operator (1) CONFIGFILE (1) configure sql server (1) connection (1) container (1) CONVERT (1) Convert File (1) Convert File Online (1) convert number (1) copy data (1) Could not load file or assembly (1) Could not open error log file (1) Create (1) create list (1) Create Proc Permission (1) Create User (1) Cross Apply (1) cross server query (1) current count = 0. (1) data (1) database (6) database backup (1) Database Comparision (1) database mirroring (1) databases (1) date (3) Date functions (1) date time append (1) DATEADD() (1) DATEDIFF() (1) DATENAME() (1) DATEPART() (1) datetime (2) DAY() (1) db mail setup (1) dba (2) dd hh (2) ddl trigger (1) delete empty error log (1) Delete Empty Error Log Files With Dynamic Names (1) delete empty file (1) delete flat file (1) deployement (1) Derived column (1) design table (1) designers (1) dll not found (1) dml trigger (1) Drop (1) DTS_E_OLEDB_EXCEL_NOT_SUPPORTED (1) duplicate rows (1) dynaimc query (1) dynamic name (1) dynamic query (1) dynamic ssis file (1) Dynamically (1) email (1) ENCRYPTION (1) enterprise-it (1) ER Diagram (1) erro 1060 (1) error 1060 (1) error files (1) error handling (1) ERRORLOG (1) EvaluateAsExpression (1) excel (4) excel and sql server (1) Exception (1) Executing SSIS Package (1) expand (1) export (1) export from file (1) Export table in to txt (1) export to excel (1) EXPRESSIONS (1) Failure sending mail (1) File (1) file name set dynamically (1) file system task (1) FileNotFoundException (1) find column (1) find from all database (1) find sp (1) find sp and table (1) find stored procedure (1) First name (2) flat file (2) Flow Charts (1) fonts (1) for (1) for each (1) for loop (1) for vs foreach (1) foreach (1) Foreach ADO Enumerator (1) Foreach ADO.NET Schema Rowset Enumerator (1) Foreach file enumerator (1) Foreach From Variable Enumerator (1) Foreach Item Enumeration: (1) Foreach NodeList Enumeration (1) Foreach SMO Enumerator (1) format (2) format sql queries (1) format tsql (1) formatter (1) from all (1) Full Text Catalog (1) Full Text Index (1) function (2) generate (1) generate GUID in Sql Server (2) get email on mobile (1) Get Random Time (1) get scrap on mobile (1) global table (1) grant execute (1) grid (1) grid report (1) guid (2) hack (1) Handling File with multiple number of columns (1) hardcode Null (1) Hardcoding Null (1) Hour:Minute (2) Hour:Minute:Second (2) ident (1) Ident_Current (1) identity (2) identity_insert (1) import (1) important tools (1) importing from Microsoft excel (1) in database (1) integration (1) integration services (4) intergration services (1) internet (1) intro (1) invocation (1) ip (1) ISNULL (1) javascript (1) jobs (1) last name (2) line feeds (1) linked server (1) locate column (1) look up (1) macro (1) management (1) MCSA (1) MCSE (1) Merge (1) merge join (1) Messenger (1) microsoft (106) Microsoft Sql Server Certification (1) Microsoft Technologies (61) mirroring (1) mirroring sql server (1) mismatching number of BEGIN and COMMIT statements (1) mm ss (2) MONTH() (1) ms excel (1) ms sql (1) multiple column (1) multiple config files (1) multiple tables (1) Music (1) Naming Conventions (1) Nested Transaction (1) new features (1) new line (1) newid (2) Noise Words (1) Non-Clustered Index (1) numeric to english (1) numeric to text (1) OLE DB Command (1) ole db provider (1) oledbcommand (1) Online Web IM (1) open query (1) Operand type clash: int is incompatible with xml (1) Operating system error = 5 (1) optimization (1) orkut (1) orkut tricks (1) Outer Apply (1) package (1) passphrase (1) performance tuning (1) php proxy (1) pinal dave (1) plugins (1) Power of CTE (1) Prevent saving changes that require the table to be re-created (1) previous cell (1) Previous count = 1 (1) Primary Key (1) proxy (1) proxy server (2) query (1) query dynamic (1) Radio (1) random (2) random time (1) range (2) RDF (1) recover data (1) recover the deleted (1) recover the updated data (1) References (1) remove duplicate (1) replace special (1) report (1) Reporting (2) restart (1) Restoring Accidentally deleted data (1) Restoring data (1) Restoring Database (1) Restoring Deleted Rows (1) Restoring Modified Rows (1) Run (2) run from command (1) RUN In 32 Bit mode (1) RUN In 64 Bit mode (1) s (1) Schema Binding (2) Scope_Identity() (1) scrap (1) Script (2) search column (1) security (2) server (1) server rejected the sender address (1) services (1) services.msc (1) Set identity_insert table_name ON (1) shortcut (1) showplan_text (1) single query (1) single query update (1) software (1) split (2) Split Name (2) sql (7) sql and me (1) sql azure (1) sql azure overview (1) sql ERRORLOG (1) sql merge (1) sql query (1) Sql Server (74) sql server 2008 (2) sql server coding (1) sql server table (1) SQL Server Tools (1) sql t (1) SQL_Latin1_General_CP1_CS_AS (1) SQLCMD (2) sqlwb (1) SSIS (19) ssis 2008 (1) ssis deployment (1) ssis error (1) ssis error handling (1) ssis expression (1) SSIS Expression To Append Time and Date (1) SSIS Script task (1) ssis task (2) ssis text file (1) ssis xml (1) ssms (4) SSRS (3) SSRS Reporting Subscription (1) starting service (1) STARTTLS (1) Stop Words (1) Stored Procedure (1) Stored Procedures Comparer (1) Subscription (2) SUBSTRING (3) System.Reflection.TargetInvocationException (1) table (1) table find (1) table variable (1) tabs (1) taddins (1) task (2) task ssis (1) technology (3) temp table (1) temporary table (1) Time (5) time range (1) tips (3) To insert data into Identity Column (1) Tool (1) tools (1) top (1) Top with ties (1) top without ties (1) Transaction count (1) Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1 (1) transaction log full (1) Transcount (1) tricks (2) triggers (1) Trim Leading quotes (1) trim quotes (1) trim trailing quotes (1) unicode characters (1) update (1) Update Mutiple Tables in Single Query (1) Updated Rows restore (1) usp_FindTableOrStoredProcNameInAllDatabase (1) view (2) warning (1) without backup restore (1) working with excel (1) XML (2) xml datatype (1) YEAR() (1)

About Me

Bhavpreet Singh Narang

View my complete profile

Search This Blog

Blog Archive

► 2013 (52)
- ► June (2)
- ► May (8)
- ► April (17)
- ► March (25)

▼ 2012 (47)
- ► July (6)
- ► June (10)
- ► May (3)
- ▼ April (5)
- ► March (8)
- ► February (5)
- ► January (10)

► 2008 (7)
- ► August (1)
- ► July (6)

Simple theme. Powered by Blogger.