SOLVED
IF a cell in the data contains X number of characters
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
missteran
7 - Meteor
‎08-21-2024
08:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alteryx community - looking for some help here. I have an excel file as an input, but the excel file has a column without any leading letters and leading zeros.
Overall the number of characters should be in total 9 characters: 3 leading letters (in the example below the three leading letters should always be ABC) and 6 overall numbers.
What is happening is in the excel file i am getting only the final pieces of the numbers excluding the leading ABC and any leading zeros. Is there a formula that i can do the After view below?
Before
1234
58678
910
After
ABC001234
ABC058678
ABC000910
Solved! Go to Solution.
1 REPLY 1
binuacs
21 - Polaris
‎08-21-2024
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator