how can I move some information from one column to 3 coulumns
e.g * BARBARA PARK + SCHOLASTIC = 2006
need
* BARBARA PARK
in one coulumn
+ SCHOLASTIC
in another and
= 2006
in another it all resides in the same column now
how can I move some information from one column to 3 coulumns
e.g * BARBARA PARK + SCHOLASTIC = 2006
need
* BARBARA PARK
in one coulumn
+ SCHOLASTIC
in another and
= 2006
in another it all resides in the same column now
depending on your layout you can use Text To Column option
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
on way with text in a1
in b1 =LEFT(A1,FIND("+",A1)-1)
in c1 =MID(A1,FIND("+",A1),LEN(A1)-LEN(B1&D1))
in d1 =MID(A1,FIND("=",A1),255)
or going along with text to columns
use find replace
first find + replace ^+
then find = replace^=
then data/text to columns/delimited
use ^ in other as delimiter click next
you'll see your 3 fields click on the top of each and change from general to text by choosing the text option in column data format on the right hand side (if you don't change to text the field that has + in will return a value error) click finish
Last edited by martindwilson; 06-27-2010 at 05:40 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks