Replace # with ' from original data

		Microsoft Office Forums > Microsoft Excel > Excel
Replace # with ' from original data

03-11-2021, 10:05 PM

Purfleet

Windows 10 Replace # with ' from original data

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

Try =IF(ISNUMBER(MID(C3,2,1)+0)=TRUE,SUBSTITUTE(C3,"#" ,"'"),SUBSTITUTE(C3,"#",""))

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
newb - search and replace - WILDCARDS - keep original...?	Bansaw	Word	4	09-01-2016 11:16 AM
Replace contents form 1 workbook with another based on simular data	shabbaranks	Excel	1	12-05-2012 11:11 PM
Hyperlink/Data Insert & replace	jclinton	Word	1	09-19-2012 07:22 PM
data change how to convert to original	gsrikanth	Excel	6	12-30-2011 08:01 AM
How to restore original data format - from a .pdf file to Excel columns	KIM SOLIS	Excel	1	09-18-2011 10:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 AM.