remove character in a cell

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

FAQ

Thread Tools

Display Modes

03-12-2020, 05:02 PM

cefd1

Windows 10 remove character in a cell

Office 2019

Novice

Join Date: Jul 2019

Posts: 10

remove character in a cell

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

« 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 05:06 AM.