How to add a tab in the middle of a text in a cell
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I need to change the raw data, #6E5, as shown below, to the desired output like this: #6E5 #.
Output desired:
String no 0 is #
String no 1 is 6
String no 2 is E
String no 3 is 5
String no 4 is tab (not space)
String no 5 is #
How to add a tab in the middle of a text in a cell?
Thank you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @susanlucky
I looked for how to add a tab tab character. But seems like there is no easy straight option for it.
8 spaces makes a gap of a tab. I have used it to get the output.
Output:
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @atcodedog05,
It should be a tab. I need the format to upload the data. I did try the 8 spaces to make it look like a tab but the system did not accept it. The picky system only accept a tab. Thank you for your kind advice 🙂
Susan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Well then all the best 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think @atcodedog05 solution is the best option. However, you can try pasting an ASCII space or ASCII char and check if that works for you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Amarendra you are a genius
Hi @susanlucky
Here is a solution. Formula
[Raw data]+CharFromInt(9)+"#"
CharFromInt convert Ascii to character. 9 is Tab so inserts tab.
Output:
Workflow:
Please check and let me know.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@acodedog05, Yes, the CharFromInt formula works! Thank you very much!
@Amarendra, Thank you very much for your suggestion!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂 @susanlucky
I think thats the best part of community new learnings.
Cheers and Happy Analyzing 😀
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm glad it worked out and welcome to the community!
