Break string into cell (Column)

**itselflearn** · 06-30-2013, 02:45 PM

Hi. I would like to know if it's possible to distribute each character into each cell. Here is the scenario:

A1=BIRD

Goal:

B1 = need formula so that it will contain letter "B"
B2 = need formula so that it will contain letter "I"
B3 = need formula so that it will contain letter "R"
B4 = need formula so that it will contain letter "D"

Thank you.

**zbor** · 06-30-2013, 02:47 PM

Try with

Formula:

=MID($A$1, ROW(A1), 1)

**MarvinP** · 06-30-2013, 02:50 PM

Put this formula in B1 and pull it down.

=MID($A$1,ROW(),1)

**itselflearn** · 06-30-2013, 03:27 PM

zhor and MarviP.............You are the best. Thank you very much.

Now how do i make it distributed rowwise starting from B1? Thank you again.

**zbor** · 06-30-2013, 03:30 PM

Just change reference

Formula:

=MID($B$1, ROW(A1), 1)

**itselflearn** · 07-02-2013, 12:43 PM

thank you very much for all your help. I really appreciated it.

Break string into cell (Column)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Break string into cell (Column)

Re: Break string into cell (Column)

Re: Break string into cell (Column)

Re: Break string into cell (Column)

Re: Break string into cell (Column)

Re: Break string into cell (Column)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions