Hi ,
Is there any formula by which I can locate special character in a string in excel. Don't want a macro for it just a formula using if condition, if possible.
Hi ,
Is there any formula by which I can locate special character in a string in excel. Don't want a macro for it just a formula using if condition, if possible.
What special character?
A1:Formula:Please Login or Register to view this content.
B1:Formula:Please Login or Register to view this content.
B1 value is 5
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
By special character I meant "!@#$%^&*()".. is there any formula to identify these characters. Basically I want to Pick the initial value of an Alphabet and then align it with one figure. i.e. if it is Alphabet "England" it should pick "E" and publish "Alphabet", if the name is "1 England" it should pick 1 and should display "Number" and if it is ": England" it should pick ":" and should display special character
Name Initial Display
England E Alphabet
1 England 1 Number
: England : Special character
Display is what I want as a result using if or any condition. Can any excel master help me out with this?
Use this VLOOKUP Table
0Special Character 48Number 58Special Character 65Alphabet 91Special Character 97Alphabet 123Special Character Then for a formula (let's say the table is in I1:J7)
=VLOOKUP(CODE(LEFT(A1,1)), $I$1:$J$7,2)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks