Prev Previous Post   Next Post Next
  #1   Report Post  
Jean-Francois
 
Posts: n/a
Default replace command

Hi, I used the replace command as follow:
=REPLACE(J474,FIND("/",J474),255,"") but now I see in my file that is not
only a slash i have in my format column. Can anybody have a way to specify,
if do not find the slash just copy the content.
Here are some exemple what i can find other than my slash:
120 g
50 Livret
200's
25 Refill
This is other than an slash but i need to copy them not replace.

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
Replace using wildcards jeb Excel Discussion (Misc queries) 6 January 6th 05 03:35 PM
macro to Find Replace in Excel Nurddin Excel Discussion (Misc queries) 7 January 3rd 05 04:29 AM
command button in excel will move when print. [email protected] Excel Discussion (Misc queries) 1 December 29th 04 03:53 PM
canot remove command from FILE MENU EXCEL CUstomization Excel Discussion (Misc queries) 2 December 7th 04 01:10 AM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"