|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 28th 12, 08:02 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Separation of text - concatenate excel
I am creating a text to number conversion - non VBA / Not Macro based.
Where A=1, B=2,... Z=26 A Word in A1=Apple - I want to break it up in to C1 - A C2 - P C3 - P ......... Need to know how to break this word up? Opposite of concatenate? Then I will have Vlookup to get the values for each alphabet and add them up and get the number value of apple. All suggestion to making this better or only breaking this up will do. Thanks. 
|
| Ads |
|
#2
July 28th 12, 09:07 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Separation of text - concatenate excel
Hi,
Am Sat, 28 Jul 2012 00:02:05 -0700 (PDT) schrieb ExceLearner: > A Word in A1=Apple - I want to break it up in to > C1 - A > C2 - P > C3 - P try in C1: =MID($A$1,ROW(),1) and drag down Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| excel separation | Kevin | Excel Discussion (Misc queries) | 1 | May 9th 10 02:59 AM |
| Text Separation Function | kateconrey | Excel Worksheet Functions | 3 | May 16th 09 03:14 PM |
| separation of text and numbers in an unmerged cell | Tazeem | Excel Discussion (Misc queries) | 9 | September 16th 08 10:01 AM |
| Imported text separation problem | Dave | Excel Discussion (Misc queries) | 2 | January 14th 08 09:19 PM |
| text and number separation | SubliminalJones | Excel Discussion (Misc queries) | 2 | October 13th 05 07:46 PM |
Linear Mode
