Deleting phrases or from one point to another?

		Microsoft Office Forums > Microsoft Excel > Excel
Deleting phrases or from one point to another?

FAQ

Thread Tools

Display Modes

10-02-2015, 11:16 AM

Pecoflyer

Windows 7 64bit Deleting phrases or from one point to another?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

This formula should do the job

=TRIM(RIGHT(SUBSTITUTE(A1;"-";REPT(" ";LEN(A1)));LEN(A1)))

(replace semi-colons with commas)

__________________
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
Power Point - Deleting Legend enteries via VBA	PowerPoint_VBA	PowerPoint	4	06-07-2015 06:46 AM
Counting Keywords and Phrases	tlamae	Excel	5	05-30-2014 06:49 AM
How do I find Repeating Words/Phrases?	CCD2016	PowerPoint	0	12-01-2013 09:37 PM
Selecting text between two key phrases	Chayes	Word VBA	6	06-24-2012 06:54 PM
Automatically Hyperlink phrases	TinaIgnatiev	Word	1	12-22-2010 01:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:11 AM.