Excel tip require
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
15 March 2010
I want to transfer each character in separate cell. E.g. The word “WORK” in A1 cell should to converted/pasted/transferred as “W” in B1, “O” in C1, “R” in D1 and so on.
Is it possible in MS Excel?
Is it possible in MS Excel?
15 March 2010
Select the data to be converted.
Select > Data > Text to Columns > Fixed Width and proceed as may be required.
Select > Data > Text to Columns > Fixed Width and proceed as may be required.
15 March 2010
use split commond
=LEFT(A1,1)in B column
=LEFT(A1,2)in c column
=LEFT(A1,3)in d column
continue it.....
=LEFT(A1,1)in B column
=LEFT(A1,2)in c column
=LEFT(A1,3)in d column
continue it.....
15 March 2010
Using the left command will not give each word seperate. It will give W in the B. WO in C, WOR in D and so on.
16 March 2010
=LEFT(RIGHT($A$1,1),1) B Column
=LEFT(RIGHT($A$1,2),1) c Column
=LEFT(RIGHT($A$1,3),1) d Column
=LEFT(RIGHT($A$1,4),1) e Column
=LEFT(RIGHT($A$1,2),1) c Column
=LEFT(RIGHT($A$1,3),1) d Column
=LEFT(RIGHT($A$1,4),1) e Column
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Difference between Date of Payment and Date of Deduction?
- TDS AND ITR ISSUE
- Journal entry of busniess expenses
- LIC maturity claim whether taxable
- ITR 4 and Bank transactions
- EMI ISSUE IN HOUSING LOAN OLD REGIME
- Bank details not Visible on Traces Portal
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
