replace with tabs

[al kray]

in excel, how does one represent a tab so that commas could be replaced with tabs?

 

[Chip Pearson]

A tab is Chr(9).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

in excel, how does one represent a tab so that commas could be

replaced with tabs?

 

[al kray]

i'm not familiar with the terminology Chr(9).
how is this entered in excel? what keys do i hit in the 'Replace with:' box?

 

[Chip Pearson]

In the Replace With box, hold down the ALT key and type 0009 on
the numeric keypad (at the right of the keyboard, not the number
keys above the letters).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[al kray]

that doesn't work either. i tried it with and without numlock on.
excel is 2002 sp2

 

[Dave Peterson]

Maybe you could use a little macro:

Option Explicit
Sub testme()
Selection.Replace What:=",", Replacement:=Chr(9), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub

If this is a one time shot, you could just run that one line.

Select your range to convert.
hit alt-f11 (to get to the VBE)
hit ctrl-G
copy these two lines and paste them in that immediate window.

Selection.Replace What:=",", Replacement:=Chr(9), LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

Then hit enter.

Then swap back to excel and see if it worked.

 

[al kray]

i tried the macro, but instead of putting tabs in it puts a 'little
square box' where the commas are. when i tried to copy the 'little
square box' to this post it acts as a tab, but not inside excel.
here's 3 of them:

 

[Dave Peterson]

Tabs don't work in excel like they do in a Word Table.

I've always used 8 (or some number) of spaces.

(I wondered what you really were doing.)