Posted to microsoft.public.excel.misc

AJ[_4_]

external usenet poster

Posts: 14

Left Function

I am trying to pull certain characters based on a criteria for the third
position character.

In Column A, I could have a code such as BB11 or a Code such as BMR2. If
the third position character is a number then I only want to pull the first 2
digits BB but if the third position character is a letter, then I would like
to pull the first 3 characters BMR.

Can anyone help?

--
AJ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to nest a left function within a sumif function?	LisaK	Excel Worksheet Functions	2	April 23rd 23 11:46 AM
LEFT function-all to left of a comma?	Jennifer F	Excel Worksheet Functions	1	January 21st 09 11:19 PM
Help with LEFT function	Cam	Excel Discussion (Misc queries)	5	October 15th 07 07:32 PM
Left vs Left$ function	Andy	Excel Discussion (Misc queries)	5	May 6th 07 04:06 AM
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION	CHAIM	Excel Worksheet Functions	1	July 27th 05 09:10 PM

All times are GMT +1. The time now is 12:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us