Amit Gupta (Loosening Myself) (1508 Points)
11 February 2011
HOW TO SEPERTE MIX OF NUMBER AND TEXT INTO DIFFERENT COLUMNS
..SAY I WANT TO SEGREGATE 10000 DR INTO TWO COLUMNS
HOW TO DO??
Lalit Kumar
(Vice President )
(2213 Points)
Replied 11 February 2011
Go to Data and then go to Convert table into Text.. Select Delimited option and then ckick Next, then Delimiter is SPACE, click next and then Finish.. Both 10000 and Dr will be in seperate Cells
Surabhi
(article assistant)
(25 Points)
Replied 11 February 2011
Text to columns in data tab can b used
Amit Gupta
(Loosening Myself)
(1508 Points)
Replied 11 February 2011
Check it:
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 12 February 2011
in your file "Dr" is not written in cell
just change the format of these cells to general from custom
Surabhi
(article assistant)
(25 Points)
Replied 12 February 2011
Ya, just change to number fomat, option is in home tab
Amit Gupta
(Loosening Myself)
(1508 Points)
Replied 14 February 2011
But i want to segregate these two..Customising that would delete the dr or cr..I dnt want that
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 15 February 2011
in my opinion Dr./Cr. can't be segregated
as these are just in Formats of cell and not the data
u can saw it in formula bar
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 15 February 2011
your file seems to be exported from Tally or any other software
may be, some options at the time of exporting the file can help
if u can export it in such a way that Dr./Cr. are in data & not in format
CAclubindia
