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