Digital QA
This is where I keep the answers I find that worked...
Tuesday, May 26, 2009
Excel Formula to Remove Text after Specific Character
In this example, everything starting with the "?" is removed from text in cell B7: =IF(ISNUMBER(FIND("?",B7)),LEFT(B7,FIND("?",B7)-1),B7)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Search Digital Q&A
Trending last 7 Days
IPad is Missing Bookmarks - Get them back!
My bookmarks disappeared and I wasn't able to add any new ones after upgrading the iOS. Get your bookmarks back by turning your iPad ...
Nespresso DeLonghi Espresso Machine - How to Clean
First, I LOVE this machine!!! Low maintenance, and a fresh cup every time. No need to buy a bag of beans that will never be fresh after open...
How to Delete a Credit Card from Starbucks Card Payment Methods Online
To delete a credit card from your Starbucks Payment Methods, go to the "Personal Info" screen under " My Profile " (at w...
Blackberry - Save Attachments to Media Card
< This is not resolved. > < Have not found a resolution. You? > "Whenever I get an email with an attachment I click on...
Stop Excel from Flashing "CALCULATING" Continuously
If your Excel spreadsheet constantly flashes "CALCULATING" in the bottom status bar, it's possible calls are being made out to...
Excel - Subtract a number of days from a date
Put this formula this in any cell (except A1): =DATE(YEAR(A1), MONTH(A1), DAY(A1)-35) Assumes your date is in Cell A1 or =DATE(YEAR(A1), ...
Automatic Stock Quotes in Google Docs
Here is a list of Common Attributes for automatic stock quotes in Google Docs. This is the starter syntax (put this in any cell): =GoogleFi...
Music for your Blog - Easy Setup via SCM Music Player
Found this great music player. Super easy setup to add a music bar to your website or blog. You can see mine at the bottom of this pa...
How to transfer 'Blogger' blogs between two accounts
In blog you want to transfer: Settings, Permissions, ADD AUTHORS, Invite, (invited accepts), grant admin privileges, remove previous author...
Dual Monitors - Mirror Image
Right Click on your Desktop Select "NVIDIA Control Panel" (not "Personalize"!) Under "Display" Select "...
Tags
¢
(1)
A-ha
(8)
Administrator Rights
(1)
Adobe
(3)
Ads
(1)
AdSense
(2)
Airpods
(2)
Amazon Firestick
(1)
Anti-virus - Mac's
(1)
Anti-virus software
(2)
App Store
(1)
Apps
(6)
AutoPlay
(1)
Backup
(3)
battery
(1)
Best Buy
(2)
Best Practices
(1)
Bing
(1)
Blackberry
(20)
Blog Subscribers
(1)
Blog This
(1)
Blogger
(19)
Bluetooth
(3)
Boolean
(1)
Browsing
(1)
Bullets
(1)
Cable
(1)
Camera
(2)
Canon PowerShot S95
(1)
Cent Sign
(1)
Chrome
(17)
Cloud Storage
(1)
Coffee Break
(13)
Comcast
(5)
Conditional Formatting
(2)
Contacts
(3)
Content Scrapers
(3)
Control Panel
(1)
Copy Paste
(1)
Creative Commons
(1)
Dates
(1)
Desktop
(1)
Downloads
(1)
Drivers and Software
(1)
Dropbox
(1)
DVD Ripper
(2)
Eat
(1)
Email
(6)
Erase Data
(1)
Excel
(32)
F1 Key
(1)
Facebook
(13)
Fan
(1)
Favicon
(1)
Fax
(1)
Feedburner
(1)
Feedly
(2)
File Associations
(1)
Fingerprint Security
(1)
Fitbit
(1)
Flickr
(12)
FriendFeed
(1)
Funmoods
(1)
Gmail
(3)
GoDaddy
(8)
Google
(2)
Google Ads
(1)
Google Bookmarklet
(1)
Google Bookmarks
(2)
Google Docs
(2)
Google Email
(1)
Google Maps
(1)
Google Reader
(4)
Google Search
(3)
Google Sheets
(1)
Google Translate
(1)
Google Voice
(2)
Google+
(3)
Grammer
(1)
Gymboss
(1)
Handbrake
(2)
HDMI
(1)
HTML
(4)
iCloud
(1)
iCloud Sync
(1)
Identity Theft
(2)
Internet Connection
(1)
Internet Explorer
(4)
Internet Speed
(1)
iOS
(2)
iOS Release Notes
(1)
IP Address
(1)
iPad
(19)
iPhone
(36)
iPhone Notes
(1)
iPhone Photos
(1)
iPhone Slow
(1)
iPod
(3)
iTunes
(8)
JavaScript
(2)
Karen the Supertrader
(1)
Kindle
(1)
Large File Sharing
(1)
Lenovo
(4)
LinkedIn
(3)
Linksys
(1)
Locked Screen
(1)
Lynksys
(2)
Mac
(2)
MAC OS
(1)
mailto
(1)
Maui Salad
(1)
McAfee
(2)
Microsoft account
(1)
Microsoft Edge
(1)
Mixt Greens
(1)
Modem
(1)
Monitors
(1)
Mouse
(1)
Mozy
(1)
MS Office
(4)
Music
(2)
Music Player
(1)
Myspace
(1)
Naked Options
(1)
Nano
(1)
Network
(1)
Norton
(1)
Notepad
(1)
Office Communicator
(1)
Online Storage
(1)
Other
(1)
Outlook
(26)
Password
(1)
PC Tools
(2)
PDF
(6)
PeekYou
(1)
PG&E
(1)
Phone Calls
(1)
Photo Import
(1)
Photos
(5)
Ping
(1)
Pinterest
(2)
Plantronics
(1)
Posterous
(1)
Power
(1)
Presentations
(1)
Print Selection
(2)
Printer
(3)
Printing
(2)
Privacy
(3)
Quick Launch
(1)
Random
(4)
Remap FN Keys
(1)
Remarketing and Retargeting
(1)
Remote Connection
(2)
Research
(2)
Roomba
(1)
Router
(1)
RSS
(3)
RSS Reader
(1)
Safe Mode
(1)
SBUX
(1)
Scanner
(1)
Screen Capture
(3)
Screen Print
(2)
Search
(3)
Security
(1)
Shortcut Keys
(1)
Signature
(1)
Skype
(2)
Sleazy
(2)
Sleep mode
(1)
Slimey
(2)
SMS Message Retrieval
(1)
SnagIt
(5)
Sneaky
(5)
Sony laptop
(1)
Sony VAIO
(1)
Speck
(1)
Starbucks
(2)
Startup
(1)
Sticky Notes
(4)
Stock Market
(1)
Stolen Laptop
(1)
Storage
(1)
SVO
(1)
Symbols
(3)
Sync
(1)
Syncing
(1)
System Repair Disc
(2)
System Restore
(6)
Task Manager
(1)
Text
(1)
Text Messaging
(1)
Time
(1)
Tivo
(2)
Toolbars
(1)
Touch screen
(2)
Touchpad
(1)
Tracking
(1)
Travel
(1)
Troubleshoot
(2)
TV
(2)
Twitter
(3)
Unethical
(2)
United Airlines
(1)
URL Shortener
(1)
User Guide
(1)
Utilities
(1)
Vaio
(10)
Verizon
(2)
video to mp3
(1)
Virus
(2)
Voice Navigation
(1)
Volume
(1)
VPCSC1AFM
(1)
Wayback
(1)
Wi-Fi Protection
(1)
WiFi
(4)
Windows
(9)
Windows 7
(5)
Windows 8
(1)
Windows Explorer
(2)
Windows Mail
(4)
Windows Screensaver
(2)
Windows Vista
(5)
Windows Welcome Screen
(1)
Windows XP
(1)
Wireless
(3)
Wish List
(1)
Word
(10)
Wordle
(1)
XBOX
(1)
Xfinity
(2)
Yahoo Mail
(5)
Yahoo Voice
(1)
YouTube
(2)
Zip
(1)
Blog Archive
►
2022
(2)
►
November
(1)
►
July
(1)
►
2021
(3)
►
March
(1)
►
February
(2)
►
2020
(6)
►
October
(3)
►
July
(1)
►
May
(1)
►
February
(1)
►
2018
(4)
►
December
(3)
►
April
(1)
►
2017
(6)
►
September
(2)
►
August
(1)
►
April
(1)
►
March
(2)
►
2016
(14)
►
November
(2)
►
October
(3)
►
September
(1)
►
August
(1)
►
June
(1)
►
May
(1)
►
April
(1)
►
March
(1)
►
February
(1)
►
January
(2)
►
2015
(18)
►
November
(2)
►
October
(4)
►
July
(2)
►
May
(1)
►
March
(3)
►
February
(4)
►
January
(2)
►
2014
(34)
►
December
(2)
►
November
(1)
►
October
(8)
►
September
(1)
►
August
(1)
►
July
(4)
►
June
(5)
►
May
(1)
►
April
(1)
►
March
(4)
►
February
(1)
►
January
(5)
►
2013
(39)
►
December
(6)
►
November
(3)
►
October
(1)
►
September
(1)
►
August
(5)
►
July
(1)
►
June
(11)
►
May
(1)
►
April
(2)
►
March
(1)
►
February
(4)
►
January
(3)
►
2012
(134)
►
December
(6)
►
November
(6)
►
October
(8)
►
September
(18)
►
August
(7)
►
July
(5)
►
June
(6)
►
May
(12)
►
April
(12)
►
March
(27)
►
February
(13)
►
January
(14)
►
2011
(131)
►
December
(5)
►
November
(15)
►
October
(5)
►
September
(5)
►
August
(12)
►
July
(49)
►
June
(24)
►
May
(5)
►
April
(2)
►
March
(1)
►
February
(3)
►
January
(5)
►
2010
(56)
►
December
(7)
►
November
(6)
►
October
(2)
►
September
(8)
►
August
(2)
►
July
(1)
►
June
(6)
►
May
(3)
►
April
(8)
►
March
(4)
►
February
(5)
►
January
(4)
▼
2009
(83)
►
December
(3)
►
November
(6)
►
October
(17)
►
September
(9)
►
August
(5)
►
July
(7)
►
June
(12)
▼
May
(9)
Excel Formula to Remove Text after Specific Character
Add Browser Toolbar Buttons: "Send to Blogger", "A...
How to Search across Multiple PDF Files
Add Google Bookmark Link to Chrome
Add "Email a Link" to Chrome
Temporarily Disable Mcafee
How to get a personalized FaceBook URL when they d...
Ping to Test Internet Connection
Remove Line in Word Document
►
April
(15)
Print Friendly
Subscribe via RSS
Posts
Atom
Posts
Comments
Atom
Comments
Twitter
Follow @beckysnyder
Follow @beckysnyder
Music ♫
Sia - Elastic Heart
Badass Jackson - Honis Sweet
Charlotte Gainsbourg "5:55"
No comments:
Post a Comment