Solved: Tab character

Hi all,
Is there a character I can enter in Excel, which converts to a Tab when the cell contents are pasted into Word. I've tried Alt + 9 with no success.
MD

Hey MD,

You could use char(9)

I just put ="a"&CHAR(9)&"b" into a cell, copied it, then in word did Edit / Paste Special / Unformatted Text
Pasted as "a b"

Matt

thats odd, when I pasted it in (and when I see it in word) there is an actual tab there, although in word its really only one character long (same as normal tabs)

The requirement is for use in this ongoing project, where I would like imported text to fit defined tab stops.
(save the xls file in C:\Amerge)

Cool program by the way :)

Anyways, as an example, I changed B6 to be ="35 South London Road"&CHAR(9)&"Apt 2" and when I clicked on Add1 it shows the tab in the textbox. when i double click it, the space is there between the Road and Apt, and Apt starts at the next tab stop

I may be missing something though..

You're right Matt, I must have been careless with my quotes, the = sign or something.
Thanks,
MD

Not a problem, you may want to have a worksheet_change event in there or something saying something like
[vba]if not isnumeric(target.text) and if left(target.formula)<>"=" then
target.formula="=""" & target.text & """"
end if[/vba]

that way if you forget to enter text in that manner (which would be annoying to do every time), it does it for you

Just a thought

BTW, the code may have written a couple of values to your registry

Private Sub SaveData(TBox, Data)
SaveSetting "TxtSelect", TBox, "Data", Data
End Sub

Quote:

---

Originally Posted by mdmackillop

BTW, the code may have written a couple of values tp your registry

Private Sub SaveData(TBox, Data)
SaveSetting "TxtSelect", TBox, "Data", Data
End Sub

---

as long as it doesn't slow down my computer i dont really care :)

Hi Matt,
I've updated the Excel file in the zip file to change the word "tab" to Char(9) and add the = sign etc. Seems to work. :)
MD

Thats a smart idea! You may want to change it to #tab or something just in case one of the cells needs to contain the actual word tab.
Glad you got it straightened out!

Good idea,
I've also sorted out a #Var routine that inserts a macrobutton in word to allow for easy insertion of variables

Hey, MD. Is this solved, then?

:)

Slap on the wrist!!!

ROFL!!