ExcelBanter - Function choice

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function choice (https://www.excelbanter.com/excel-worksheet-functions/196213-function-choice.html)

Anne903

Function choice

Hi
I would like to use a function or formula that would take the first 6
characters (combo of alpha & numeric) and copy them into an adjacent column.
This is to be able to set up a filter and/or pivot table
Anne

Wigi

Function choice

=LEFT(cell,6)

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music

"Anne903" wrote:

Hi
I would like to use a function or formula that would take the first 6
characters (combo of alpha & numeric) and copy them into an adjacent column.
This is to be able to set up a filter and/or pivot table
Anne

All times are GMT +1. The time now is 06:29 PM.