Autofill Text

I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but find that I cannot autofill unless the series contains numbers or dates. Can any one suggest a simple answer for this as I am not an experienced user of EXCEL. It seems that filling in each series individually is the answer but it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers
0
12/24/2003 9:16:05 AM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
368 Views

Similar Articles

[PageSpeed] 14

"Ryko" <sourcemusic@tsn.cc> wrote in message
news:ADBE64DF-285A-4050-B88E-A98BFCD84CD4@microsoft.com...
> I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but
find that I cannot autofill unless the series contains numbers or dates. Can
any one suggest a simple answer for this as I am not an experienced user of
EXCEL. It seems that filling in each series individually is the answer but
it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers

I think you need to create a "custom fill series" for this sort of thing.
Full details are in Help.


0
Paul
12/24/2003 9:39:32 AM
One way?

Say, to fill the series aaa - aaz

Put in say, B1: ="aa"&CHAR(ROW()+96)

Copy B1 down 26 rows to B26

B1 to B26 returns aaa - aaz

Above uses the "a" to "z" returns by char(97) to char(122),
viz if you put in a cell : =CHAR(97) >> it returns "a"

ROW() - which returns the row ref,
is used as an incrementer
(e.g.: ROW() in B1 returns "1")

So, just adjust accordingly the formula depending on
where you want to fill the series down from
(the total inside CHAR(..) must equal 97)

--
hth
Max
-----------------------------------------
Please reply in thread
Use xdemechanik <at>yahoo<dot>com for email
---------------------------------------------
"Ryko" <sourcemusic@tsn.cc> wrote in message
news:ADBE64DF-285A-4050-B88E-A98BFCD84CD4@microsoft.com...
> I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but
find that I cannot autofill unless the series contains numbers or dates. Can
any one suggest a simple answer for this as I am not an experienced user of
EXCEL. It seems that filling in each series individually is the answer but
it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers


0
demechanik (4694)
12/24/2003 9:52:47 AM
Hi

When starting from cell A1:
A1=CHAR(INT((ROW(A1)-1)/676)+97)&CHAR(MOD(INT(((ROW(A1))-1)/26),26)+97)&CHAR
(MOD((ROW(A1)-1),26)+97)
and copy down

-- 
(When sending e-mail, use address arvil@tarkon.ee)
Arvi Laanemets



"Ryko" <sourcemusic@tsn.cc> wrote in message
news:ADBE64DF-285A-4050-B88E-A98BFCD84CD4@microsoft.com...
> I am trying to create a series of text sets, eg. aaa-aaz, aab-abz, but
find that I cannot autofill unless the series contains numbers or dates. Can
any one suggest a simple answer for this as I am not an experienced user of
EXCEL. It seems that filling in each series individually is the answer but
it's a lot from aaa to zzz. Would be greatful for any assistance. Cheers


0
garbage (651)
12/24/2003 10:04:08 AM
Marvellous one, Arvi!

Gives me a hell of a headache
trying to figure how it works, though  <g>

Rgds,
Max
-----------------------------------------
Use xdemechanik <at>yahoo<dot>com for email
---------------------------------------------


0
demechanik (4694)
12/24/2003 10:21:36 AM
Reply:

Similar Artilces:

Active X text box control
I want to put a text box in a cell. I have followed all the instructions I can find and it still isn't working. I try to type in the box and then go to another cell and the text shows up in the cell behind the text box. What am I doing wrong? The Active X textbox control comes from the control toolbox. To adjust it's settings you need to put the sheet into Design mode by clicking the first button on that toolbar (looks like a triangle, pencil and ruler). Right click the text box and select Properties. Add a cell address to the Linked Cell and then Exit Desing mode. T...

Averaging a column that contains text
On my worksheet I have a column of12 cells that I need to average. Unfortunately cell B6 contains text (see below). As shown the dreaded #DIV/0! displays in cell B13 until any rates are inputted into the column. After inputting the first rate the formula works great. I’m using the formula; =AVERAGE(B1:B12). Is there another formula I could use that will not display the #DIV/0! in cell B13 ? I’m using Excel 2007. A B 1 2 3 4 5 6 Name 7 ...

How to get the text from another window?
hi,all For example, In MSDN help program, there are many items in the left list box when you type whatever key word. Can I get these itmes' text in anohter program? I did a test, put a CListBox in a dialog and then , in another program, get the handle of this list box and use list.Attach(handle) , then you can get all text by the list. But in msdn help program, it is not a CListBox, how to do that? Is possible? Thanks What exactly do you mean by the MSDN list box? Are you talking about the part of the Index where the topics are listed? -- Alec S. alec <@> synetech &l...

How do I count the amount of text in a column and then add them
For example I would like to count the number of Mondays inserted into a column and then sub total. Thanks =COUNTIF(A:A,"Monday") Peter Curtis wrote: > For example I would like to count the number of Mondays inserted into a > column and then sub total. > > Thanks ...

text wrap problem
Hi all I'm importing address info into Excel from our in-house database. Th addresses comes as a block with line breaks which show up as a squar in Excel (when text wrap is off). I need to change these marks int commas. Is there any way to do this automatically? I dont have VBA knowledge but suspect this is where the answer lies. Apologies if this is an innane question to some but Im stumped. Cheers Lo -- Message posted from http://www.ExcelForum.com From a previous post: Chip Pearson has a very nice addin that can help identify those funny characters. http://www.cpearson.c...

Add Text To Multiple cells
I am working on this project & I cant figure out how to add a letter in front of each number in a cell without clicking in to each individual cell and typing it in. (very time consuming and tedious) The problem is - it's not all the cells but a majority, all of the numbers are in the same column. To explain, these are documents in storage. Each item is assigned a number (not in any particular numerical order but they have to stay in the order they are. Example: X39655 X39656 X39711 39662 39664 39665 The last three numbers need the X in front of them. Any ideas? Thanks so much...

sum text box porblem
Hi, I have a text box for sum a group of text box in sub form. When I run the form, it works. But when I run the form using another form” run the form from other form by using a button” the sum text box does not work. Can any body tell me what is wrong? your help is highly appreciated. thx. Can you post the formula you are using as the control source as it may refer to the main form - and of course - if open the subform on it's own the reference will not point to anywhere. Post the formula and someone will no doubt be able to help -- Wayne Manchester, England. "ghost&quo...

Problem copying from one text box to another.
I am trying to copy the contents of a text box in one spreadsheet and paste it in a text box in another spreadsheet. But when I do this in the normal manner (Ie selecting the old text and clicking the paste button to replace it), the old text is still visible under the new text, sort of like a double exposure on a photograph. Any idea why this should be or what I can do about it? ...

Excel "Text to column"
I need to export data from a database I am working with, to an exce file, to make it easier for me to edit certain changes. For one part of this, all of the data appears in one cell (seperated b delimeters.) I use the "text to columns" function, to change the data into multipl columns to make it much easier to read, work with, and edit. My problem, is changing it back to the one cell, so that I may the import it back to my database. Part of my excel sheet looks like this after the text to column: 2325 test where the large blank space is two empty cells. I know the correct ...

Attachments are being added to plain text messages
Last month there was an exchange of postings about a change in the behavior of Outlook for messages in "plain text" format. For a period of several days (in my case, from December 15 to December 19), every message received by Outlook in "plain text" format had an attachment added to it. The attachment is a .TXT file. The name of the file is the same as the subject line of the message. The text of the .TXT file is the same as the text of the message. Although this odd behavior stopped on December 19, it's Baaaaack. Beginning yesterday (2005/01/09), all plain text ...

Receiving in Plain Text
I have tried to change to receive my e-mail in HTML format and the box to check is grayed out so I cannot choose it. Is there a way to change this. I have outlook 2002 Thanks MIke Are you using Word as the editor? What happens if you turn off Word? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Mike Shrout asked: | I have tried to change to receive my e-mail in...

Truncated text when copying text from one excel doc to another
launch two excel documents Enter a long text string into any cell >500 characters Copy the cell and paste it to any cell in the other document Result: the pasted text is truncated losing the end of the original text string. How can I fix this? Should'nt happen as you described - except there is a problem with cell formatted as TEXT and a cell data length 512 to 1024 characters (the cell is displayed as ##### symbols) From a worksheet, if you Move & create-a-copy a worksheet there is limit on the contents of a cell size, but Excel will tell you of thi at the time of the copy....

Can't Access E-mail Addresses in Text of messages
I can't access E-mail addresses in message text such as the following: Buyer: j.bowersmd@comcast.net Subject: Payment for ebay auction Amount: $9.03 USD Shipping & Handling: $2.00 USD I need to access the e-mail address j.bowersmd@comcast.net from the message itself. Does anyone know if and how this can be done? Thanks. Ray Sanborn Is the message sent as plain text? If so, you can't click on it. Note - if you've posted a valid address here, that poor person is going to get flooded with spam and SWEN viruses. Never ever post valid email addresses in usenet posts (and a...

format a formula to general (not text)
I am importing a text (.csv) file into excel and formatting it via a Macro. in one column I have to insert a formula but when I do so, the formula is showing, i.e. "=TRIM(Z4)". I have tried to format to "general" but it doesn't work unless I click inside the cell and press enter. How do I apply the "General" formatting without have to manually click inside the cell? I want to do it in my macro. Here is my code: ActiveCell.Formula = "=TRIM(Z4)" Selection.NumberFormat = "General" -- www.bardpv.com Tempe, A...

Shared calendar does not show text in appointments
I've had a request for help because a user on our network, who has access permission to her bosses calendar, has a problem. When the PA sets new appointments she can see botht he new item and all the other appointments, whether she set them up or her boss did. However, when the Boss looks in the calender for herself, the ones set up by the PA show as blank spaces, but the subject line does not show the text. The PA knows how wto do this and IS using the subject line properly to detail what the appointment is for. Honestly, I'm baffled - I've never heard of this before. Any ideas ...

how to activate text to speech
dear friends how to activate the text to speech bar ???????? -- frsm ------------------------------------------------------------------------ frsm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31231 View this thread: http://www.excelforum.com/showthread.php?threadid=519641 Pll-down: View > Toolbars and check text to speach This requires a recent version of Excel -- Gary's Student "frsm" wrote: > > dear friends > how to activate the text to speech bar ???????? > > > -- > frsm > ---------------------------...

Difference between Text Area and Text?
Can anyone tell me the answer to this question? Cheers A textarea accepts multi-line text values. A text accept single-line text values. HTH, -- Jeffry van de Vuurst CWR Mobility www.cwrmobility.com -- "Saira" <Saira@BayonetVentures.com> wrote in message news:%234vNYbtbGHA.3872@TK2MSFTNGP04.phx.gbl... > Can anyone tell me the answer to this question? > > Cheers > i assume when we make attribute for text area we use (ntext) . The max length is 5000. regards Aami Jeffry, thanks, but am i being a bit dense. Is the difference something to do with lin...

Clicking on text box that not revisable
Hi. I have a text box on a form that is not editable by the user. It displays an automated number from the associated table. It's shaded so the user gets the hint that it's not enterable or editable. However, it is enterable if you click on it. It also becomes unshaded when you click on it. You still can't revise the number but I'd like it to not be enterable at all. Any suggestions? -- Sue Programmer/Data Analyst Minnesota Set its Enabled property to No. "Sue" <Sue@discussions.microsoft.com> wrote in message news:18EBC3C9-6F3A-4F7F-AC1F-80DA5593...

how do I concatenate text that has a quotation mark
how do I concatenate text that has a quotation mark in it like th following html: <img width="76" height="25" src="blah" -- sparkrom ----------------------------------------------------------------------- sparkroms's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2503 View this thread: http://www.excelforum.com/showthread.php?threadid=38564 Replace the quotation mark with its ASCII character equivalent: 34. I put 76 in A1, 25 in B1 and blah in C1. Then I used this formula: ="<img width="""&A1&&...

Summing an array based on text condition
Hi, I have the following columns I would like to create an automatic formula to sum: Person Sales AL/AS 30.0 AL 25.0 AS 20.0 The formula should detect a person's initials (e.g. AL or AS in this example) and only sum if they are either wholly or partly involved with the sales. Where they are jointly allocated (e.g. AL/AS) only half of the sales revenue should be added. So the correct formulas would return: AL 40.0 AS 35.0 I was trying to use the sumproduct function with an embedded Left() and Right() functions. However the left/right functions do...

How can I get text to equal a numerical value in Excel?
I am developing a scheduling program for my workplace. The program will automatically calculate total time scheduled based on times entered (i.e., 8:00AM start time in one cell, 5:00PM end time in the next cell calculates to 9 hours in a third cell). However, we need to indicate days off, vacations and leaves of absences. When we enter text into the first cell, it obviously destroys the calculation in the third cell. I need to be able to have Excel assign a value of "0" for any cell that has text. Thanks, Mike Mike, I fixed similar problems in my files by using the if &am...

Text Box
Hi, I have a report that pulls from a cross tab that comes from a make table querey. In the report I need the ability to have a text box where the agent can enter certain data when promoted. For example =[Enter End Date] or =[Enter Reporter Name] However, when I enter this into a text box I am recieving a error that states that it is not reconginzed as a valid field name or expression. How do I get around this? Omit the = sign at the start of your expression. HTH, Rob "awalker" <awalker@discussions.microsoft.com> wrote in message news:3D99E055-67DC-42FE-B88D-35...

Publisher crashes when I touch the last text block
I use multiple pages for my websites, continuing the text from page to page. For some reason, the very last page is extremely sensitive, so that if I put a cursor on that text block, the program crashes. What to do? Sam What version of Windows and Publisher are you using? Update your video drivers from the website of your video card manufacturer and that will fix your issue. -- ...

text to columns #3
I have an invoice that I cut and paste whole network application screen onto to fill out the invoice. It works really well using the text t columns feature (delimited, spaces). However, when I close the exce session, it no longer will be delimited. How do I fix this? Thanks, Vat -- Message posted from http://www.ExcelForum.com If you want to save the de-limiting, SAVE the workbook If you don't, don't. -- Don Guillett SalesAid Software donaldb@281.com "Vato Loco >" <<Vato.Loco.19fyvo@excelforum-nospam.com> wrote in message news:Vato.Loco.19fyvo@excelforum-no...

Can excel display text in CHART's data table?
All my text are displayed as "0".......just want to keep some comments nicely in there.Not sure whether excel can do this. Or anybody knows other better way? something like this: para1 1.2 1.3 1.4 para2 1 7 100 comments bad good excellent Hi, The chart data table is very limited in terms of formatting. You would be better using cells to display the information you want. And position the chart above them Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "8uv" <8uv@discussions.m...