Deleting phrases or from one point to another?

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

FAQ

Mark Forums Read

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

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:21 AM.