Word TAB function in an excel cell

Hello everyone,

I am having a formating issue within a cell. I would like to acomplish a TAB space between to words so they allways have the same space between, no mather how many characters the words or numbers have.

Example:

I insert text and numbers from diferent cells in to one.

Formula:

INDIRECT("AI"&ROW())&"    "&INDIRECT("AK"&ROW())&" "&TEXT(INDIRECT("AJ"&ROW());"###'###'##0.00")&"         "&INDIRECT("AM"&ROW())&"          "&INDIRECT("AL"&ROW())&" "&TEXT(INDIRECT("AN"&ROW());"###'###'##0.00")&"          "&INDIRECT("AO"&ROW())&"

It looks like this... so far so good.
25.02.2014 EUR 5'600.00 1.2177 CHF 6'819.12 Withrawal

But if i insert multiple lines with higher or lower amounts the formating goes wrong.

25.02.2014 EUR 5'600.00 1.2177 CHF 6'819.12 Withrawal
26.02.2014 EUR 10'000.00 1.2212 CHF 12'212.00 Deposit

The target would be to keep straight lines like with the TAB in Word.

snap-tab.jpg

I know there is no TAB whitin excel cells, but maybe there is a way to set a default charachter lenght that can be forced even if the amount or the text is shorter.

I would be most greatfull for any help i have been sitting on this one for quite some time now.

Can you upload your xls file?

Sorry it took me a little time to make the file small enugh for upload

Statment Project Development V 1.1.xlsm

It is alittle long and it loads currencie ex rates from oanda that is why it contains macros.

in the Sheet "Statements" row "AG"

Thank you for thaking time to help me, it is very much apreciated.

Why all those 'indirect' formulas

INDIRECT("AI"&ROW())
AI3

These 2 gives the same result

Take a look at my xls sample
Here you can see how to fix it

You must change your font
In font 'Calibri' not all letters have the same width (eg i and w)
Font 'Courier' have the same width