Thread: Replace # with ' from original data
View Single Post
 
Old 03-11-2021, 12:30 PM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
  
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default Replace # with ' from original data
Hi,

I'm seeking for some help with formula to take out the # from order column and replace with '. I have to keep the order column as is.

ORDER Result
#000009439 ='000009439
#CLR000387 CLR000387
#2000000692 ='2000000692

Many thanks,
Haha88
Attached Files
File Type: xlsx Fomular help.xlsx (9.5 KB, 12 views)
Reply With Quote