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
