How to add a tab in the middle of a text in a cell

[susanlucky]

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

[atcodedog05]

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 🙂

[susanlucky]

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

[atcodedog05]

Well then all the best 🙂

[Amarendra]

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

[atcodedog05 · Accepted solution]

@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.

[susanlucky]

@acodedog05, Yes, the CharFromInt formula works! Thank you very much!

@Amarendra, Thank you very much for your suggestion!

[atcodedog05]

Happy to help 🙂 @susanlucky 

I think thats the best part of community new learnings.

Cheers and Happy Analyzing 😀

[Amarendra]

I'm glad it worked out and welcome to the community!