| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert column to text
Hello,
I want to convert a column with "SSN" title in text but I don't know where the column is located. The programation below gives me the first column wich contains SSN title. Does anyone know how to find an exact match of the SSN title ? Thanks! } Set rng = wks.Rows(1).Find(What:="SSN") } If Not rng Is Nothing Then rng.EntireColumn.TextToColumns Cells(1, rng.Column) -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert column from numbers to text | Excel Discussion (Misc queries) | |||
| Convert text to column | Excel Worksheet Functions | |||
| convert column data into text | Excel Discussion (Misc queries) | |||
| convert a column of text to proper | New Users to Excel | |||
| Convert text to column | Excel Programming | |||
Threaded Mode
