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 on Deemed Capital Gain
- Type of Capital Gain
- Exiting partner in partnership firm in gst portal
- Banking Related Issue
- ASMT-10 received from A O
- ITR-3 File/Error Found
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- Difff in ais receipts and gst turnover
- Gst on travel by air for business purposes
- Can a single LLP in India legally operate multiple unrelated businesses (Travel, Cloud Kitchen, Ecom
- CASH GIFT FROM BLOOD RELATIVE
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- Rent claimed on building given on permissive possession basis
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
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
