Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 28th 12, 08:02 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 3
Default 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.

  #2   Report Post  
Old July 28th 12, 09:07 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,729
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


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 10:19 PM
text and number separation SubliminalJones Excel Discussion (Misc queries) 2 October 13th 05 07:46 PM


All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017