Replace CR/DR with +/- in Excel by simple steps

How to replace Dr/Cr with +/- in Excel of Data Exported from Tally by 2 ways.

1) In Excel, select the amounts and then go to Ctrl + F then type _Cr (Spacebar Cr) then go to Lookin menu and select values then find all option then select all resulted lines and colour it from home menu and close Ctrl+F. You will find all Cr as coloured and you can apply formula in blank cell =Concatenate("-", Cell)

2) In Tally, Export data in ASCII Mode then that exported file will open in text format then copy all data from that in paste in Excel sheet then select all data and go to Text to Data Column menu then Delimiter then select comma menu then finish.

Replies (2)
Quick Summary
Methods to replace Dr/Cr with +/- in Excel from Tally export data. One method uses Excel Find (Ctrl+F) to identify Cr values and convert them using formulas. Another method involves exporting in ASCII mode, pasting into Excel, and using Text to Columns for formatting.

OK possible
  • Method 1 (Formula): Best for dynamic sheets linked to raw data exports.

  • Method 2 (Flash Fill): Best for instantaneous, manual-free conversion.

  • Method 3 (Find & Replace): Best for cleaning raw text columns in-place before financial analysis.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details