#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Try =IF(ISNUMBER(MID(C3,2,1)+0)=TRUE,SUBSTITUTE(C3,"#" ,"'"),SUBSTITUTE(C3,"#",""))
|
#3
|
||||
|
||||
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) |
Thread Tools | |
Display Modes | |
|
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 |