|
|
#1
03-11-2021, 12:30 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 8 
Office 2010 32bit
Threaded Mode