Hello friends,
i need a command which can help me in consolidation of data. i have exported some party name from busy software, then pasted to another workbook. now problem is in using sumif formula. In exported data, there is lots of space in a cell after text while in pasted data there is no space as same. now problem is how i can change the exported data as just simple typing text.
please help me if that is possible
Though it depends data to data, but you can trya, while pasting on exceld dono directly hit Ctrl+v, rather than that rght click on the particular cell, there musr be an option of Paste Special, try Text only....or Unicode text...this may help.
Shyam S Gupta and Company
New Delhi
CA Inter
View Details
M N Rao & Associates LLP
Vijayawada
CA Inter
View Details
CCI
Pro
CAclubindia
