Hi all,
I'm trying to extract a particular text between two commas and am looking for some help. I have an address in A1 which I'm hoping to extract 'XYZ' from and show 'XYZ' in A2.
A1: 123 ABC Street, XYZ, NY, 12345
A2: XYZ
I've used the formula below, but it's showing cell A2 as ' XYZ'. Any ideas how to extract it without the space before the text?
Formula:
Please Login or Register to view this content.
Try this
Please Login or Register to view this content.
=TRIM(your formula) will remove the space.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Your formula works if you add the TRIM function to the beginning:
TRIM(...)
This one is a few keystrokes shorter:
=TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",100)),100,100))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Awesome, thanks a lot guys!
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks