Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Startwith if test

Status
Not open for further replies.
mart10

mart10

MIS
Nov 2, 2007
394
GB
I am using Excel 2003

I want to test if the contents of a cell starts with certain charaters. How do I do this please?
 
Sort by date Sort by votes
Hi,

Check out the LEFT function.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cneill
  • Locked
  • Question
Combining If and Iferror and Index/Match with Hyperlink
Replies
18
Views
555
cneill
cneill
AndyBellers
  • Locked
  • Question
Regarding: thread68-1090780 If y
Replies
0
Views
171
AndyBellers
AndyBellers
Cpreston
  • Locked
  • Question
If cell is blank use data from another cell 1
Replies
10
Views
293
Andrzejek
Andrzejek
jlr123
  • Locked
  • Question
Excel formula- If and 1
Replies
1
Views
144
Andrzejek
Andrzejek
IcarusHallsorts
  • Locked
  • Question
Split text string of Fname, Mname (if present) & Sname into two columns 1
Replies
9
Views
324
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top