break down a string in a cell

yoko

Active Member
Joined
Sep 5, 2006
Messages
349
Hi,

Bit of a vague subject but what I want to do is take a message written in a cell and break it down.

What I need the spread sheet to do is take each letter in the message and depending on the letter and whether it’s the 1st, 2nd, 3rd etc letter and do something with it.

Is it possible to do this?

At the moment I have the message written over a range of cells so the word "the" is spread over 3 cells bit it would be easier if the message could be entered into one cell then broken down in to each letter.

Cheers,

Scott
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Artorius

Board Regular
Joined
Apr 18, 2006
Messages
176
Can you not use the LEFT, MID and RIGHT functions to achieve this? Not sure if this helps ......
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Scott

You can certainly split the word(s) up by individual letter by using the MID function eg:

=MID(A1,2,1)

would take the second character in the string (so the from your example above).

Really does depend on what you want to do with the letters subsequently.

Best regards

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,114,053
Messages
5,545,740
Members
410,703
Latest member
yaronjoseph
Top