Hi Guys,
I need assistance with part of the text I need to remove from text out of a cell?
The cell contains both the product name and product code in brackets. The problem is that the product code is not always 6 numbers for example so I can't use the Right function to isolate the product numbers.
Attached is a sample! I need to extract only the product codes in brackets?
Any ideas?
Fugly
Perhaps..
=MID(A1,FIND("(", A1)+1, LEN(A1) - FIND("(", A1) -1 )
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try
=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("(",A1)),")","")
Life's a spreadsheet, Excel!
Say thanks, Click *
=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("(",A1),LEN(A1)),"(",""),")","")
copy down
Works like a bomb, thank you!
Oh that was for all 3 solutions, thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks