Truncating a columns worth of cells not just a single cell.

R

rebates

If I have a "column A" containing +5000 entries, with each cell being
name, how do I create a "column B" next to it with each cell being th
first initial of the name in "column A"?

I know I can use the "LEFT" function in the forumla bar to convert
single cell, but I don't know how to apply it to a column with a cel
range so I dont' have to do this +5000 times, and worse - on about 11
different spreadsheets.

I tried clicking on "Column B" and entering LEFT(A1:A5231) after th
"=" sign in the formula bar, but as soon as I typed the colon it sai
invalid character. It was acting like I couldn't use this to create
formula for the column.

I'm sure there is a way to do this for a column if there is a functio
that will do this for a cell.

Please help
 
G

Govind

Hi,

In Column B , you should use =LEFT(A1,1) and copy it down to all the
values in column A.

Regards

Govind.
 
Top