ExcelBanter - Copy parts of cell

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copy parts of cell (https://www.excelbanter.com/excel-discussion-misc-queries/83708-copy-parts-cell.html)

Mike Mike

Copy parts of cell

I need to copy the first 8 characters from one cell to another like this:

lampshades
cheapcars
fluffybunny

will be

lampshad
cheapcar
fluffybu

Regards
Mike

Mike Mike

Copy parts of cell

I just found it: =LEFT(A1, 8)

"Mike Mike" wrote in message
m...
I need to copy the first 8 characters from one cell to another like this:

lampshades
cheapcars
fluffybunny

will be

lampshad
cheapcar
fluffybu

Regards
Mike

All times are GMT +1. The time now is 11:32 AM.