Hello!
I am a new excel user and I am trying to solve my problem. I have one cell which contains a lot of words that are splitted by commas ,e.g. : In the cell A1 I have : Date,Open,High,Low,Close,Volume,Adj Close
But I want to split them into separate columns (A1 will contain word Date , B1 will contain word Open, C1 will contain word High and so on..). Can you help me?
Hello and welcome to the forum.
Use the Text to Columns feature and specify the comma as the delimiter.
http://support.microsoft.com/kb/214261
Thank you very much, it works now![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks