Hi,
I have a situation here, I have some data from web-site, when I copy paste these data to Excel is only in 1 cell and i would like to split it into multiple rows by comma.
An example attached.
Thanks for kindly help in advance!!
Best Regards
Hi,
I have a situation here, I have some data from web-site, when I copy paste these data to Excel is only in 1 cell and i would like to split it into multiple rows by comma.
An example attached.
Thanks for kindly help in advance!!
Best Regards
I think TEXT to COLUMNS option, is the best way here.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Or
In A2 cell
Formula:Please Login or Register to view this content.
Drag it down.........
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
And if you want rows - select all cells; copy - paste special - transpose
Dear Dudes
Thank you very much for your help!!!
Best Regards
Andrew
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks