Thread: Replace # with ' from original data
View Single Post
 
Old 03-11-2021, 10:05 PM
Purfleet Purfleet is offline Windows 10 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, 5 views)
Reply With Quote