Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Replace # with ' from original data
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-11-2021, 10:05 PM
Purfleet Purfleet is offline Replace # with ' from original data Windows 10 Replace # with ' from original data Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Try =IF(ISNUMBER(MID(C3,2,1)+0)=TRUE,SUBSTITUTE(C3,"#" ,"'"),SUBSTITUTE(C3,"#",""))
Attached Files
File Type: xlsx Copy of Fomular help_purfleet.xlsx (10.1 KB, 7 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace # with ' from original data 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
Replace # with ' from original data 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 11:31 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft