SOLVED
substitute formula in excel
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
rohini
8 - Asteroid
‎01-23-2020
03:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I have a data where the reference number is something like bg/ nngk/nm d /1355, I want to remove the blank and the "/" from the reference number. I use =SUBSTITUTE(SUBSTITUTE(L2,"/","")," ","") formula how can this be done in alteryx.
thank you
Regards
rohini
Solved! Go to Solution.
Labels:
- Labels:
- Developer
4 REPLIES 4
17 - Castor
‎01-23-2020
03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Replace(Replace(Column, "/", "")," ","") just ensure Column is replaced with the field/column with the reference number in a formula tool.
16 - Nebula
‎01-23-2020
03:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @rohini ,
it's very similar to Excel ... use "REPLACE" instead of "SUBSTITUTE" and remove the "=" and you are done.
Formula is: Replace(Replace([Field1], "/", ""), " ", "")
Best,
Roland
‎01-23-2020
03:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you
ThizViz
11 - Bolide
‎01-23-2020
01:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Kindly click "Accept as Solution" for both these answers.
@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)