How to have charac in new column with 40 char length only...

Posted to microsoft.public.excel.misc

Rajat[_2_] Rajat[_2_] is offline

external usenet poster

Posts: 2

How to have charac in new column with 40 char length only...

I have a below requirement:
In one column i am having some words of different-different length, e.g some
70 charac., some 60,50,100,90 etc.

but i want to have all of them copy to new column but with length only 40
charc....rest of the charac i don't want....
plz help.

Thanks
in advance
Rajat

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How can i create a 2-D stacked column within a 4 series stock char	Sam	Charts and Charting in Excel	6	July 9th 09 07:34 AM
Excel 2007 - mixed type (line, column, stacked column) in one char	Mike	Charts and Charting in Excel	0	August 5th 08 06:33 PM
FIND 1 char in cell of any 3 char =True	Nastech	Excel Discussion (Misc queries)	5	April 26th 08 02:17 PM
8500 cells with phone number(7 char.), wishing to add area code (10 char.)	[email protected]	Excel Discussion (Misc queries)	6	March 10th 06 05:13 PM
Question regarding : CHAR(64+COLUMN())	Andrew	Excel Discussion (Misc queries)	2	February 22nd 06 11:03 PM

All times are GMT +1. The time now is 09:30 PM.

Menu

About Us