Easy Office
Easy Office

Excel tip require

This query is : Resolved 
Avatar

Querist : Anonymous

Profile Image
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?
Profile Image

Rasesh

Profile Image

Rasesh (Expert)
15 March 2010 Select the data to be converted.

Select > Data > Text to Columns > Fixed Width and proceed as may be required.
Profile Image

Ram Avtar Singh

Profile Image

Ram Avtar Singh (Expert)
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.....
Upgrade to CAclubindia Pro. Subscribe Now!

Profile Image

Rasesh

Profile Image

Rasesh (Expert)
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.
Profile Image

Ram Avtar Singh

Profile Image

Ram Avtar Singh (Expert)
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

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries


CCI Pro

Trending Online Classes

view all classess


Answer Query



Quick Links