remove character in a cell

		Microsoft Office Forums > Microsoft Excel > Excel
remove character in a cell

FAQ

Thread Tools

Display Modes

03-13-2020, 12:31 AM

macropod

Windows 7 64bit remove character in a cell

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Quote:

Originally Posted by Marcia

What I do is to select all the cells that need editing>Ctrl F>type '-' in the Find What box>click on the Replace With>Replace All

That, however, would remove all the hyphens...

Judging by the posted example, one needs to Find ' - ' and replace with ' '. Or, as per the OP's request, a formula could be used:
=SUBSTITUTE(A1, " - "," ")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Max Character per cell + spread over other colums	lily	Excel	4	03-29-2015 07:08 PM
I want Marco solution to remove specific Raw having only .(dot Character)	PRA007	Word VBA	2	12-04-2014 01:53 AM
How do I output special character to a specific cell (x,y)?	norwood	Word VBA	2	01-31-2014 01:26 PM
Display a label character in a data cell	markg2	Excel	9	09-07-2013 05:56 AM
Remove first character from text file	dwillyfan	Word VBA	1	09-04-2012 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 PM.