How do I cut column back to first 2 characters? Thanks－software｜痞客邦

Aug 28 Tue 2007 20:38
How do I cut column back to first 2 characters? Thanks

close

After pasting data into a new Excel column, I need to limit the new Column to
first 2 characters only.

Thanks

You may not need to paste at all

Assuming the data you want to copy is in column A:

In cell B1 enter the formula =Left(A1,2)

Copy this down as many rows as you need.--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=539154

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Template becomes Unprotected
此分類下一篇： duplicate workbooks
上一篇： Need to round a formula up or down to a specific number
下一篇： negative times

歷史上的今天

2007: query for work help! showing final result
2007: HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS?
2007: Duplicating cell value between worksheets
2007: Add comments into email body using VBA
2007: Footer Defaults
2007: Sharing Data Between Worksheets
2007: Excel
2007: Command Button Assignment
2007: How do i not plot values as zero?
2007: returning specific text only
2007: Auto Pareto Chart
2007: 2nd post
2007: How can I get excel to show ALL lines of wrapped text?
2007: Problem with Windows in Taskbar command
2007: how do i round to the nearest 0.5 in excel
2007: How do I print a column of number in COLOR?
2007: print and print preview not active in file drop down
2007: Lockup in Office
2007: Get a Worksheet name through a function
2007: Pocket Excel
2007: mail merge to include signatures
2007: Formatting Cell To Display Value Instead Of Formula
2007: display dates with ordinals
2007: Excel menu bar missing
2007: random plotting
2007: Totals skipping columns
2007: Find precentage result
2007: Newby questions
2007: custom event
2007: Macro in excel to save to an unmapped drive !
2007: combination charts
2007: how do i find palindromes using excel?
2007: Pasting from Excel should let me to show references
2007: Run a macro from cell select
2007: ncaa template
2007: Very strange error
2007: Furmula Dependent Cell References
2007: x-axis is time ... sort of
2007: Collecting weekly and monthly totals from daily data
2007: which line mercy script
2007: removing duplicate rows
2007: missing personal.xls file ... please help!
2007: Unwanted Links
2007: HOW DO I DELETE SHAPES THAT ARE IN SPREADSHEETS?
2007: Delete empty rows from print in Excel
2007: How to have multi plots in one chart or graph?
2007: Grid column display text trimming
2007: Data Labels
2007: Sort Groups of Cells
2007: I want glitter images to insert
2007: Trouble printing message 'print to file'
2007: CTRL D
2007: How to count interstitial blank cells?
2007: How do I sort by EBCDIC sequence in EXCEL?
2007: Values to a folder name on desktop
2007: Lists and sub lists
2007: A function that looks for a value on a sheet on unknown column or row
2007: Inserting lists from a drop down menu????
2007: Default Information Showing Up
2007: Find and replace
2007: average with mulitple ciriteria
2007: NUMBER WATERMARKS
2007: Multiple screen splits for same worksheet in Excel
2007: How do i insert of spacer rows between rows in large spreadsheets
2007: How do I get Excel to generate an ex-gaussian distribution?
2007: Files links
2007: Auto Fill Series when number ends in -1
2007: How to make quot;This workbook contains links to other data sourcesquot; appear?
2007: Multiple Variables in a Commission Structure...a tough one!!!
2007: VBA project is protected
2007: linked cells change to literals
2007: Some Macro Help Please
2007: sorting a list
2007: Excel
2007: Function for upper and lower control limits?
2007: 30 day planner template
2007: Excel 2000 Pivot Table Calculated Fields
2007: To add a name of label on several sheets.
2007: Adding a List of Members to a shared workspace
2007: LIST DATES IN MONTH ORDER
2007: How can I display two seperate stacked bars in a graph
2007: Average first 3 numbers in column e.g. 130 in 130/82
2007: I would like to view both worksheets in a file. Possilble? How?
2007: Pivottable to count non-zeros
2007: hOW DO i MAKE A COLUMN SLIDE ALONG WHEN I'M SCROLLNG SIDEWAYS
2007: Can I remove a hyperlink without removing the color of the cell?
2007: How to hide the outlook toolbar when opening an excel file
2007: AYUDAME A PAGAR MIS DEUDAS Y DE PASO RECIBE TAMBIEN DINERO.....
2007: Tab Key Expanded Cell Movement
2007: Excel User Conference
2007: average of several cells excluding the minimum
2007: Transferring data from MS Access to MS Excel
2007: How can I get a postal code in a cell
2007: Is it possible to apply conditional formating to a pivot chart?
2007: How do i get my data to transfer to another work sheet?
2007: Capitalization?
2007: receipts
2007: Excel suddenly requests the instal disk!
2007: How do I stop mouse from highlighting cells automatically
2007: restrict users

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)