Hi Members,
I have 900 roll numbers (numeric 6 digit) in column A i want to put all these roll numbers in single cell with space in between each of them - all 500 roll numbers should come in single cell e.g C1.
I know that we can do this with concatenate but that is to lenghty process so need ur help.
Thanks..
Bookmarks