remove character in a cell

cefd1 · #1 03-12-2020, 05:02 PM

I have a worksheet that has data listed examples: 9-2 - Washington and 9-2-30 - Washington.

Is there a code that removes the last hyphen between the numbers and beginning of letters that I could drag down my column for a large worksheet?

Thanks

Marcia · #2 03-12-2020, 08:59 PM

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
The single quote in the '-' is for clarity only.

macropod · #3 03-13-2020, 12:31 AM

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, " - "," ")

ArviLaanemets · #4 03-13-2020, 02:14 AM

Replace "- " with "". Replace All. (between numbers, hyphens are followed with number immediately, so they aren't replaced)

cefd1 · #5 03-13-2020, 05:16 AM

Thanks, got it working

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