Text in string

		Microsoft Office Forums > Microsoft Excel > Excel
Text in string

FAQ

Thread Tools

Display Modes

11-05-2014, 12:46 PM

Pecoflyer

Windows 7 64bit Text in string

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Hi
the easy way is Data - Text to columns - use / as delimiter and select to not import the columns you don't need in the last step of the wizard

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM
Extracting a phone number from a string that contains text and numbers.	hommi16	Excel	2	06-05-2013 09:19 PM
Find and replace a string of text	errtu	Word	1	01-31-2013 02:09 PM
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM
Extract numbers from a text string	aleale97	Excel	4	02-10-2011 10:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:30 AM.