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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

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
 

Forum statistics

Threads
1,140,916
Messages
5,703,161
Members
421,278
Latest member
16cwilliams

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top