Replace # with ' from original data

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

03-12-2021, 01:46 AM

Pecoflyer

Windows 7 64bit Replace # with ' from original data

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

If your purpose is to make text out of a number without loosing the leading zeroes try

Code:

=RIGHT(TEXT(C3;"0");LEN(C3)-1)

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 08:50 AM.