FORMATING COLUMNS..... HELP

I need to format columns to allow only 7 characters and the rest of the data 
to go into column B   
-- 
JTEFUN
0
JTEFUN (1)
7/3/2007 5:12:07 PM
excel.newusers 15348 articles. 2 followers. Follow

4 Replies
625 Views

Similar Articles

[PageSpeed] 29

"JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message 
news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com...
>I need to format columns to allow only 7 characters and the rest of the 
>data
> to go into column B
> -- 
> JTEFUN
>


If you mean that if a user types a lot of data into the one cell and that 
when they reach 7 characters the rest of the data is automatically inserted 
into the next cell, then I don't think you can do that. (Might by code - 
someone will tell you...) 


0
gbplinux (1141)
7/3/2007 5:29:38 PM
"JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message 
news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com...
>I need to format columns to allow only 7 characters and the rest of the 
>data
> to go into column B
> -- 
> JTEFUN
>


If you mean that if a user types a lot of data into the one cell and that 
when they reach 7 characters the rest of the data is automatically inserted 
into the next cell, then I don't think you can do that. (Might by code - 
someone will tell you...) 


0
gbplinux (1141)
7/3/2007 5:29:38 PM
Please, do not multipost


-- 
Regards,

Peo Sjoblom



"JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message 
news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com...
>I need to format columns to allow only 7 characters and the rest of the 
>data
> to go into column B
> -- 
> JTEFUN 


0
terre081 (3244)
7/3/2007 5:33:24 PM
"JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message 
news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com...
>I need to format columns to allow only 7 characters and the rest of the 
>data
> to go into column B
> -- 
> JTEFUN

Column A: Input
Column B: =LEFT(A1,7)  will abstract the first 7 characters
Column C: =MID(A1,8,99)  will abstract characters 8 through 99

Regards.

Bill Ridgeway
Computer Solutions 


0
Bill
7/3/2007 6:31:08 PM
Reply:

Similar Artilces:

newbie needs help
Hello, First to let you all know, I am a big novice at this kind of stuff, so please bear with me. What I am trying to do is make a trendchart with 9 different plots on it. How do I change the numbers on the side and bottom of the chart to read what I need them to? I take these tests 3 times a week and would like to chart all of them seperately and also together to chart progress for a whole month. One for each day, and then one for the month. Then I would like to do the same for the following months of the year. And I would like to have one chart to show the progress for the whole...

clustered stack column charts #2
I am trying to create a chart with three stacks in two columns. I tried using the method described by Bernard Liengmen's but it doesn't allow me to add a secondary axis for the last (sixth) data series. I don't get it??? How does one series in a stacked cluster use the secondary axis? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lou T wrote: > I am trying to create a chart with three stacks in two columns. I tried > using the method described by Bernard Liengmen's but it ...

Help! Unable to mount public folder store event 9519
Hi, I am getting the following error when tring to mount the public folder store. Event Type: Error Event Source: MSExchangeIS Event Category: General Event ID: 9519 Date: 11/01/2006 Time: 00:10:26 User: N/A Computer: SERVER Description: Error 0x8004010f starting database "First Storage Group\f7967383-856a-4b7f-9023-37c269a0e908" on the Microsoft Exchange Information Store. Look up of DB Info failed. For more information, click http://www.microsoft.com/contentredirect.asp. I have tried numerous ms kb articles to no avail. I did find this on a news group :- -------------...

Formula help/suggestions?
I'm looking for help some help with a formula. How would I go about a formula for automatically adding 8 hours to a number each calendar month? I would like to open it and have it done for me if that's possible rather than having to remember to add it each month or forgetting if I did or not. For instance, i start out with the # 248 in a cell that I would like to automatically add 8 to each calendar month. "Gadgetman" <stoojz3@yahoo.com> wrote in message news:stoojz3-96EE83.15151022012011@usenet.ptd.net... > I'm looking for help some help with a formula....

Creating a view with concatenated columns
I have a table with about 20 columns and I am trying to create a view of it that includes about 10 columns. The problem is that in the process, I am trying to concatenate some fields into one field and I am unable to get any thing working. Below is one example of my attempts to tackle this. Any ideas will be highly appreciated. // The following should be considered as pseudo-SQL CREATE function [dbo].[fn_myview] (@CardNo varchar(11)) returns Table as BEGIN declare @FullName as nvarchar(128) (SELECT FirstName, FatherName, GFatherName, FamilyName, Birthdate, Birthplace...

Conditional Formatting for a certain month
Having a bit of an issue at the moment, ive got the Cell for instance A1 Which contains 04-Jan-06 Basically Im after some conditional formatting to say if the month is January, then make the cell blue. Which will then lead to me making the other cells different colours depending on their month, but again, it has to be in this format (DD-MM-YY) Thanks for any help, muchly apreciated Assuming a properly formatted date, formula is =if(month(a1)=1) -- Don Guillett SalesAid Software dguillett1@austin.rr.com "Advo" <max_mischief@hotmail.com> wrote in message news:1158151582....

Rich Text control formatted as bold??
I have a control field on my form that is setup as textformat = rich text. In the memo field on the form I need specific parts of the text to show up as bold. Upon form load I am populating the field with string data such as: Me.MyTextBox = "This is a test string generation." I need to set bold only one or two words of this string. The way I understood it was that if I was using Rich Text format it would convert the formatting to HTML style. But I don't see and havent found examples HTML formatting like [b] [/b] working in VBA. What is the correct way I can do t...

I need help with a formula
Hi everyone I'm making a stock list sheet and I like to put on it the value - and + .. like when I take boxes out it will give me the total and when I add in it will change also. This is for a weekly count. I'm very new to excel so please H-E-L-P-. I need the instruction like u give it to a child. :) :) Thanks a lot -- pampam ------------------------------------------------------------------------ pampam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26224 View this thread: http://www.excelforum.com/showthread.php?threadid=395241 We need ...

formula help 02-10-10
Hi- Issue: 211 310 410 569 Would like to accomplish: 2211 2310 2410 2569 How do I add number 2 infront of the above ISSUE numbers as I have thousands of line to do. Soth If your number is in column A then in column B type =2 & A1 and copy it down. -- -John http://www.jmbundy.blogspot.com/ Please rate when your question is answered to help us and others know what is helpful. "Soth" wrote: > Hi- > > Issue: > 211 > 310 > 410 > 569 > > Would like to accomplish: > 2211 > 2310 > 2410 > 2...

conditional formating #4
I have an annual report spreadsheet comprised of 15 rows (1 - 15) and 5 columns (A - E). In columns "B" and "D" I add numbers from the current year, leaving future year cells blank. I highlight in yellow the blank future cells in columns "B" and "D" by a conditional format "formula is = ISBLANK(B9)". I leave past year cells in "B" and "D" with numbers but no highlight colors. I wish to highlight in green the current year numbers in columns "B" and "D", which will always be a cell above the firs...

formatting of txt file
Hi, Can anybody can help me in in formatting the below data for me The below data is coming in a txt file and i need the data in a excel file However when i put in excel i am not getting any structured form I need the Reference mentioned against the numeric value in the separate column as heading and the data below should come below the heading. I have tried, but i have to a lot of manual edit after formatting. 1.Emplyoee name bsdcbasdb hbvabfvas 2.Date 12-12-09 3.Address Dettails 12/2 main street City - bvauisdbc Pin code- 1100154 4. Department snbvsivnsvn oihbvis...

Open Spreadsheet--Formatting Changed to Date??
I opened my spreadsheet and some, but not all of the columns on every sheet in the workbook has changed to a date format. I opened other spreadsheets and there was no change. Can anyone explain this. It's a real pain to deal with. ...

Display lists in an arbitrary number of columns
I have written and posted the following articles which will prove useful = to some: Display Lists in Columns Horizontally Using One Cell per Column http://www.braintrove.com/default.aspx?p=3D3&s=3D1&i=3D34 Display Lists in Columns Horizontally Using Individual Cells http://www.braintrove.com/default.aspx?p=3D3&s=3D1&i=3D33 Display Lists in Columns Vertically Using One Cells per Column http://www.braintrove.com/default.aspx?p=3D3&s=3D1&i=3D32 Display Lists in Columns Vertically Using Individual Cells http://www.braintrove.com/default.aspx?p=3D3&s=3D1&i=3D31 ...

Need Exchange limit help
I have a new SBS 2008 Server setup in a manufacturing environment. Two users within the company send and receive large CAD files. How do I allow this process? Right now one user is try to send a 185MB file and it is saying "the message being sent exceeds the message size established for this user." I have tried setting the limit in the console to 10GB and now I have unchecked the "enforce the mailbox quotas" box and he still can't send. If I go into the Exchange Management Console I still don't see how I can make this work. Is this something that...

COUNTIF with adjacent columns
I have a spreadsheet which has a list of tasks in one column and directly next to it whether that task is complete/not complete/ rescheduled. For example in cell B2 the task is CL and in column C2 the task is complete: B C 2 CL Complete I would like to add a tally box at the bottom for all CL tasks which are complete, then another for not complete and another for rescheduled. At the moment, I can only get it to COUNTIF on either the CL or the complete value but not both together. Any help greatly appreciated! Try this: A B C ...

COUNTIF using formatting?
Here is a basic example of what I'm trying to do: I have a list of football teams. Each week, I format the football teams that won with red font. Is there a way to find a count of those teams formatting in red and display that number in my worksheet? I know an alternate way around this would be to have a win/loss column and do a COUNTIF based on the values there. But I'm wondering if there's a way to do it based on the formatting instead of the values. Nicolle K. wrote: > Here is a basic example of what I'm trying to do: > > I have a list of football team...

Help with Hurricane Database
I work at the Corporate office of a fast food chain. We have almost 1000 stores in 10 states - mostly in the South. We have many stores in the hurricane zones. During Rita and Katrina we decided we needed a better way to track how our stores are affected and what help we could provide. I've designed a database to do this. I have three main tables: tblHurricane Info: fldHurricaneYear fldHurricaneName tblUnitInfo: fldUnit - the unit number assigned to the store fldAddress fldCity fldState fldZip fldPhone fldDO fldMgr tblUnitForm fldAutoNumber fldUnit fldHurricaneName fldPr...

Stop Excel Changing Format
In Excel I want to just show a date as dd/mm in a cell. Every time I enter this Excel shows the number in dd/mm/yy format, even when I change the cell to use the General format. Any idea how I get Excel to show the number as I want? Format as dd/mm -- David Biddulph "Chris762" <Chris762@discussions.microsoft.com> wrote in message news:D028B2CD-5096-4EB5-8FFF-249AD6839774@microsoft.com... > In Excel I want to just show a date as dd/mm in a cell. Every time I enter > this Excel shows the number in dd/mm/yy format, even when I change the > cell > to...

How to split numbers and decimal in 2 columns
One column for the dollars and the other for the cents? If so, use the Text to Columns, Use Delimited as the split option (Step 1) and select Other, type in the decimal point in the blank to the right of the Other option in step 2. This is good, but how do i keep it in the colums is i introduce new data and how do i sum it up (the colums) to get a final number with decimals in there corresponding colums? Dollars in in B, cents in C, Data shown Dollars Cents Cu Sum 7 56 7.56 3 44 11.00 2 24 13.24 45 23 58.47 C2: =SUM($B$2:B2)+SUM($C$2:C2)/100 and copy down Regards Peter A "...

Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you enjoy the respect and additional income that could come from being able to help everyone in your office on Microsoft Outlook? Get your Outlook Specialist certification and realize the benefits it can have. "Are You Certifiable (In Outlook, At Least)" is available at http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go through each subject on the test and help you to prepare for this certification. If you do not plan to get certified but need a little extra help on using Outlook it is an excell...

Formula for adding up columns, i.e., B1:B10 + D1:D10 + F1:F10 + H1:H10 + J1:J10
I've never figured this one out. Went and googled yet again but I'm obviously not googling for the right thing. Same as with the help file. What is the type of formula we use for adding up columns or rows, esp. if they're broken up by rows/columns in between? Thanks! =SUM(B1:B10,D1:D10,F1:F10,H1:H10) -- Regards, Peo Sjoblom "StargateFanFromWork" <noSpam@NoJunkMail.com> wrote in message news:ORPkLEa1FHA.2792@tk2msftngp13.phx.gbl... > I've never figured this one out. Went and googled yet again but I'm > obviously not googling for the right t...

Font format of rich edit ctrl in dialogs, Help!
Hi, I have used a lot of rich edit ctrl in my dialogs (I am sorry that I haven't use edit ctrl instead) and I found one problem now. The text displayed initially in the ctrl (set by DoDataExchange()) has different font format with the text which users type in later. Any experienced people can tell me the functions to make these two font same? Otherwise I think I will have to change about 100 rich edit ctrl to edit ctrl besides a lot of codes. Thank you a lot. -- Best regards, Kelvin ...

Looking for help...I can't send e-mail using CRM web client
I'm having a problem with trying to send e-mails vie the CRM web client. When I try to send the e-mail I get a pop-up with the message in bold "Unexpected Error" "An error has occurred. For more information, contact your system administrator". I've checked the event logs, no errors are showing up in either my CRM server or my exchange server. I'm lost, new to CRM. Any help or ideas is appreciated. Thanks, You could try to add pre-windows2000 account to the administrator group on the exchange server. Some time that helps "Marty" wrote:...

Help in Query with two condition
hello all, I have a table like this: Planner Qty User6 CUT SUB BAM-06 1 CONC Yes No BAM-06 1 CONC No Yes BAM-06 1 TOC Yes No BAM-06 1 TOC No Yes BAM-06 1 TACT Yes No BAM-06 1 TACT No Yes JAXM-06 1 CONC Yes No JAXM-06 1 CONC No Yes JAXM-06 1 TOC Yes No JAXM-06 1 TOC No Yes JAXM-06 1 TACT Yes No JAXM-06 1 TACT No Yes Note: CUT and SUB are check box I want a result as follow: User6 A B C D E F CONC 2 2 1 1 1 1 TACT 2 2 1 1 1 1 TOC 2 2 1 1 1 1 WHERE: A SUM Qty =BAM-06 B SUM Qty =JAXM-06 C SUM Qty =BAM-06 if Cut=YES D SUM Qty =JAXM-06 if Cut=YES E SUM Qty =BAM-06 if SUB=YES F SUM Qty =JAXM-06 i...

Help with Date format
I want to enter dates into a worksheet like this: January 25, 2001 And i want to get excel to display the date with the following format: 1/25/01 I have tried using a date format from the format menu but it wont display the date like i want! It will only display the date as I typed it in. Thanks to anyone who can help. :) It appears you're typing the date into a cell formatted as something other than General. 1. Delete the current contents of the cell. 2. Format > Cell > Number tab. Choose a date format. 3. Now key in the date into the cell. HTH Jason Atlanta, GA >-----Or...