Tes to columns

  • Thread starter Thread starter bobby769
  • Start date Start date
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
..
 
Back
Top