Hi all,
I have attached 2 files. 1 in Excel format and other one in CSV format.
it is actually the same file.
Problem what I have is, IF I open CSV file in TEXT, I can see empty rows. which I cant see in Excel.
Number,Name,Employee
455,A,12.
5345,B,13.
345345,C,43.
4353,D,544.
345,E,76.
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
is there a way to be able to see in excel itself? its not usual that we go to CSV and see this.
many thanks!
Regards
D.
Put your cursor in A1
and then ctrl shift end
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
The empty rows are there. Technically speaking though, no you cant see them as you do in the csv as the commas in the csv are the delimiters used by Excel to split data across columns and thus arent shown in Excel.Originally Posted by dhineshreddy
So essentially something like ",," is saying to split nothing across 3 columns in Excel.
As pointed out however Excel knows the used range encompasses those empty rows from the csv however.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
this works for me.. many thanks!
thank you for the explanation!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks