Text Format/Size of Cells

C

ChiPhiZD

I have a worksheet w/ 5000 cells, and i only need the 1st 8 character
of text for a cut and paste into a web portal, is there anyway to hav
it remove all of the information that is after the 8th character....fo
ex

"abcd001 " <----they all have an extra space that i do not need, wan
to know if i can format the column to remove everything after the 8t
character


Thanks,
Chri
 
V

vandenberg p

Hello:

There are probably several ways, but I would create a helper area (or
a new sheet.) Use the following formula to pick the number of characters
to save (assume your data is in column A if it is a matrix rather
than a vector adjust the range):

In cell b1: =left(a1,8)

Copy this down for the 5000 rows.

If necessary you could do a copy/paste/values on the b column.

Pieter Vandenberg


: I have a worksheet w/ 5000 cells, and i only need the 1st 8 characters
: of text for a cut and paste into a web portal, is there anyway to have
: it remove all of the information that is after the 8th character....for
: ex

: "abcd001 " <----they all have an extra space that i do not need, want
: to know if i can format the column to remove everything after the 8th
: character


: Thanks,
: Chris


: --
: ChiPhiZD
: ------------------------------------------------------------------------
: ChiPhiZD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33196
: View this thread: http://www.excelforum.com/showthread.php?threadid=530130
 
F

Francisco GMAIL

Try copy paste

Sub Botón1_AlHacerClic()
Range("a1").Select
For i = 1 To 500
ActiveCell.Cells(i, 1).Value = "abcdefghijklmnñopqrstuvwxyz"
ActiveCell.Cells(i, 2).Value = "=left(a1,8)"
Next i
End Sub
 
Top