How to retrieve character from a string for excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to retrieve the first two character from a string for
excel?
such as there is a word in Cell B2 = "Choice", then in Cell B1, which
display only "Ch".
Does anyone have any suggestion?
Thank you for any suggestion
Eric
 

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

How to retrieve the number? 4
How to retrieve the value within string? 10
How to retrieve data from web link? 2
How to retrieve the value? 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to retrieve certain text from string? 5
How to edit the link? 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top