Subject: | |
From: | |
Reply To: | |
Date: | Wed, 31 Aug 2011 10:49:11 -0600 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Sue
char(9)
or copy a tab and paste it into place
or create a custom function using Char(9) or the pasted TAB
Stephen
------
"If you want to make God laugh, tell him about your plans." ---Woody Allen
On Aug 31, 2011, at 10:19 AM, Sue wrote:
> Does anyone know a way to include a tab in a concatenated text calculation?
>
> I have several situations where it would be nice to have a field of text that includes tabs so that the beginning letter of various parts of the calculated field line up. E.g. I have a field that returns a name and a birthday. I would like the name and birthday values to be separated by a tab instead of a set number of spaces so that I could use the List function to give me an output that looks like:
>
> Joe Smith January 1
> Sarah Johnson January 20
>
> instead of
>
> Joe Smith January 1
> Sarah Johnson January 20
>
> I tried creating a calculation looking at length of the name and returning a variable number of spaces which I then included in the calculation--eg Name & Tabcalc & birthday, but that didn't work quite right--maybe due to the different kerning for different letters (eg an i perhaps uses less space than m)?
>
> That leaves me out of ideas. Maybe it isn't possible, but if it is, I would like to know how to do it.
>
> Thanks in advance for any suggestions.
>
> Sue
|
|
|