Tes to columns

B

bobby769

In excel If I have Last name, first name in a column, I can use the feature
"text to columns" to seperate them into two columns so that Column A become
first name and Column B becomes last name
 
J

John Spencer

No, there is no feature like the Text to Column feature in Excel.

There are ways to do something like that using VBA and/Or queries. However,
those methods are not generic and normally require specific coding to do
what you want.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Non-Blank Values in a Table but only for a range 3
How to determine the text? 2
I would like to have the row and clumn numbers seen on the spread 1
sum in excel 2
Mechanism - relink linked tables within a client automatically - Access 97 - whe 1
Click to open record form 3
column to show certain percent positive AND negative 3
Date refrencing 3

Top