Find & replace a character in a particuler position

		Microsoft Office Forums > Microsoft Excel > Excel
Find & replace a character in a particuler position

FAQ

Thread Tools

Display Modes

07-27-2016, 11:27 PM

Pecoflyer

Windows 7 64bit Find & replace a character in a particuler position

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Perhaps =REPLACE(REPLACE(A1,LEN(A1),1,""),1,1,"")

__________________
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

Tags

find & replace, wildcard searches

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace a random character with the same character	RickLegrand	Word	7	07-23-2015 06:35 PM
Wildcard Find/Replace deletes extra character	Cosmo	Word	1	06-20-2014 08:49 AM
Help with the "find and replace" option; character problem	martinn4	Word	3	02-20-2014 03:52 AM
character spacing position disabled	fogharty	Word	2	07-27-2011 01:26 PM
jumping to a character position in Word	ahha	Word	1	07-23-2007 02:57 PM

Other Forums: Access Forums

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