Convert column to text - in a worksheet of a designated file.

**Jennie82** · 11-27-2021, 09:22 AM

Hi All,

I would like to have support on a code which can help to convert the Entire column A to text .
Example : I have the excel with macro file and open a designated file and would like to convert column A to that file to text and save it .
I have no idea how to code it as I tried many ways but cannot build it. Would like to have help with this.

Thanks.

Jennie.

The code I am working on - but have no clue on the conversion.

**Richard Buttrey** · 11-27-2021, 09:46 AM

What's currently in column A?

If formulae and you want to change them to values then perhaps

Please Login or Register  to view this content.

**Jennie82** · 11-27-2021, 10:12 AM

Dear Richar,

Column A value is in the Database file which I attached. I use the macro in file Format DAtabase to open and convert column A to text.

The formula is not working :

Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 2), TrailingMinusNumbers:=True

When I open the file by the macro, this formula only works in my 1st file (file format Database ) , not second file (file database).

Jennie.

**Jennie82** · 11-27-2021, 10:20 AM

Originally Posted by Richard Buttrey

What's currently in column A?

If formulae and you want to change them to values then perhaps

Please Login or Register  to view this content.

I have errors when using this formula (as attached in word) . Explanation , I have a database file , in column A, people can input Number which cause errors when I try to search from a User form.
I want a macro which can help to convert the whole column to text so all values are text .
This expectation cannot be solved when I use number format as "@" , Only solved when I go to the file and convert to text . I want to build it through VBA.