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
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