Hello Bos ?
Someone can help me please..
I have the data like this :
03/07/2009;31267400;78168 in Cell A5
And here i want change that data like this :
Cell A6 = 03/07/2009
Cell B6 = 31267400
Cell C6 = 78168
Thank's b4
Hello Bos ?
Someone can help me please..
I have the data like this :
03/07/2009;31267400;78168 in Cell A5
And here i want change that data like this :
Cell A6 = 03/07/2009
Cell B6 = 31267400
Cell C6 = 78168
Thank's b4
Last edited by antoni; 10-03-2009 at 01:52 AM.
1) copy the cell to A6
2) select A6
3) Click on Data > Text To Columns > Delimited > Comma
4) Click Finish
You can do this on a whole column all at once, not just one cell at a time.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ok. Thank's Bos
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks