getting first few characters of a cell in another one

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.


.

Relevant Pages

  • Re: Parsing Characters - Bug ???
    ... This has to do with an analyzer that colour codes individual characters ... reopening make no manual cell entries before running the macro. ... Dim char As String ... I have a complex macro that parses characters in the active cell and makes ...
    (microsoft.public.excel.programming)
  • Re: Wrap Text problem
    ... merged as a single cell, it in fact WILL display over the 256 characters I ... The actual limits are (from "Excel Specifications and Limits" ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Only Copy Subtotals
    ... Trim results in deleting everything except the last six characters. ... is where I need to remove the last six characters from each used cell. ... Once I have my subtotals copied to my totals sheet and clean the columns... ... i wrote a sub to copy the sub totals but it keys on my data. ...
    (microsoft.public.excel.programming)
  • Re: Joining Tables
    ... I have my hidden characters showing and I have my Tools - Options ... When I put my cursor at the end of the row and move one space, ... The border between the tables shows as twice as wide as a single cell ... example), but they are behaving as two separate tables, rather than ...
    (microsoft.public.word.docmanagement)
  • Re: How do I remove "special characters" from cell data?
    ... I think I'd use multiple columns to store the data. ... At the top the address breaks into 2 lines but in the cell it's one line. ... Dim iCtr As Long ... Sometimes those funny characters don't work in the edit|Find dialog. ...
    (microsoft.public.excel.misc)