Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2003

Fri 23 May 2008, 16:05 Delegate Sujata said...

Sujata has attended:
Excel Advanced course

Excel

How do you pick out a text or characters within text or characters in a certain cell.

No set Left or Right indicators

Mon 9 Jun 2008, 21:56 Trainer Katie said...

RE: Excel Text Functions

Hi Sujata,

Thank you for your question.

There are other text functions available, have you tried using FIND?

For example, finding where is "W" within postcode "NW5 6JT"
=FIND("W", cell address)

The answer will show 2 indicating "W" is the second letter.

Do let me know if this is useful.

Kind regards,

Katie
Microsoft Certified Trainer