PC Review


Reply
Thread Tools Rate Thread

Separation of text - concatenate excel

 
 
ExceLearner
Guest
Posts: n/a
 
      28th Jul 2012
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.
 
Reply With Quote
 
 
 
 
Claus Busch
Guest
Posts: n/a
 
      28th Jul 2012
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
separation of text and numbers in an unmerged cell Tazeem Microsoft Excel Misc 9 16th Sep 2008 10:01 AM
Imported text separation problem Dave Microsoft Excel Misc 2 14th Jan 2008 10:19 PM
Text String Separation TexasLegend Microsoft Excel Discussion 3 28th Dec 2005 11:13 PM
text and number separation SubliminalJones Microsoft Excel Misc 2 13th Oct 2005 07:46 PM
Bullet - Text Separation Format? Dennis Microsoft Powerpoint 5 28th Jan 2004 11:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:44 AM.