Hi I use vba macros in excel to do certain data formatting. I am looking to convert vba macros to excel formulas so that anyone without vba knowledge can use it.

Part of macro statements are as below -

strOut = Format(108, "0000000000") ' form id
strOut = strOut & Format(n + 1000, "0000000000") ' sequence
strOut = strOut & Format (strId,"000000000000000000000000000000") ' prim key
strOut = strOut & "A" ' add new entry
strOut = strOut & Space(65) & vbTab

I have converetd all the statements using autofill for sequence and text function for rest. For example replace Space(65) with "" and placing 65 spaces between quotations. But I am not sure how i can print tab space in excel. Any help plesae ?