getting first few characters of a cell in another one

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

I know there's a simple way of doing this, but I can't remember how at the
moment.

I need to have a cell return the first 3 characters of another cell.

Example

A1 B1
Example Exa

Could someone please remind me how to do this?

Thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autocopy the first cell with more than 30 characters to a different sheet? 1
Constant date in one cell 1
CONDITIONAL FORMATTING QUERY 0
Clever formula required to sum contents of cell 6
Show other cell if blank 5
Move cells 1
Macro to extract few values from a cell 3
distributing each characters on a cell 2

Back
Top