replace with tabs

A

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?
 
C

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
 
A

al kray

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

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.
 
A

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:
 
D

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.)
 
Top