LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Calculate (Auto Fill) cells with numbers and text.

I have a worksheet that I want to use text and numbers in the same cell, and
have
the column auto fill down when I enter the first number & text in the first
cell.
example.
cell A1 I would enter 28XL0001
Cell A2 should auto fill in 28XL0002
Cell A3 should auto fill in 28XL0003.

How can I get excel to do this?

 
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
Auto fill numbers and text karchivese Excel Discussion (Misc queries) 1 January 25th 08 07:23 PM
Auto fill numbers starting with zero pianogirlny Excel Discussion (Misc queries) 3 December 31st 07 03:15 PM
How to auto-fill text based on text in another cell Jason Excel Discussion (Misc queries) 3 February 16th 05 08:40 PM
I Need a Formula to Auto-fill Phone Numbers in a Range twd3lr Excel Worksheet Functions 4 February 4th 05 08:38 PM
How do I get auto fill to do decending numbers in a column? oesqueen Excel Discussion (Misc queries) 2 January 26th 05 02:55 PM


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

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

About Us

"It's about Microsoft Excel"