Want to extract specific data to another cell in Excel
![Multi tool use Multi tool use](http://sgv.ssvwv.com/sg/ssvwvcomimagb.png)
Multi tool use
000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND
I want to extract all data i.e. the whole address after 000008()-
in another cell in Excel but don't know how to do it
excel excel-formula excel-2010
add a comment |
000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND
I want to extract all data i.e. the whole address after 000008()-
in another cell in Excel but don't know how to do it
excel excel-formula excel-2010
1
Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula
– usmanhaq
Nov 24 '18 at 6:10
2
Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)
– QHarr
Nov 24 '18 at 7:01
2
show us what you have tried
– Ivan Vinogradov
Nov 24 '18 at 7:53
000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM
– Jalil Cracker
Nov 25 '18 at 9:53
As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1
– usmanhaq
Nov 26 '18 at 6:11
add a comment |
000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND
I want to extract all data i.e. the whole address after 000008()-
in another cell in Excel but don't know how to do it
excel excel-formula excel-2010
000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND
I want to extract all data i.e. the whole address after 000008()-
in another cell in Excel but don't know how to do it
excel excel-formula excel-2010
excel excel-formula excel-2010
edited Nov 24 '18 at 12:01
![](https://i.stack.imgur.com/DKnSq.jpg?s=32&g=1)
![](https://i.stack.imgur.com/DKnSq.jpg?s=32&g=1)
Lee Mac
5,40531643
5,40531643
asked Nov 24 '18 at 5:57
Jalil CrackerJalil Cracker
21
21
1
Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula
– usmanhaq
Nov 24 '18 at 6:10
2
Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)
– QHarr
Nov 24 '18 at 7:01
2
show us what you have tried
– Ivan Vinogradov
Nov 24 '18 at 7:53
000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM
– Jalil Cracker
Nov 25 '18 at 9:53
As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1
– usmanhaq
Nov 26 '18 at 6:11
add a comment |
1
Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula
– usmanhaq
Nov 24 '18 at 6:10
2
Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)
– QHarr
Nov 24 '18 at 7:01
2
show us what you have tried
– Ivan Vinogradov
Nov 24 '18 at 7:53
000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM
– Jalil Cracker
Nov 25 '18 at 9:53
As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1
– usmanhaq
Nov 26 '18 at 6:11
1
1
Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula
– usmanhaq
Nov 24 '18 at 6:10
Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula
– usmanhaq
Nov 24 '18 at 6:10
2
2
Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)
– QHarr
Nov 24 '18 at 7:01
Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)
– QHarr
Nov 24 '18 at 7:01
2
2
show us what you have tried
– Ivan Vinogradov
Nov 24 '18 at 7:53
show us what you have tried
– Ivan Vinogradov
Nov 24 '18 at 7:53
000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM
– Jalil Cracker
Nov 25 '18 at 9:53
000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM
– Jalil Cracker
Nov 25 '18 at 9:53
As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1
– usmanhaq
Nov 26 '18 at 6:11
As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1
– usmanhaq
Nov 26 '18 at 6:11
add a comment |
1 Answer
1
active
oldest
votes
=RIGHT(A1,LEN(A1)-9)
will achieve what you say you want.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53455573%2fwant-to-extract-specific-data-to-another-cell-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
=RIGHT(A1,LEN(A1)-9)
will achieve what you say you want.
add a comment |
=RIGHT(A1,LEN(A1)-9)
will achieve what you say you want.
add a comment |
=RIGHT(A1,LEN(A1)-9)
will achieve what you say you want.
=RIGHT(A1,LEN(A1)-9)
will achieve what you say you want.
edited Jan 4 at 3:41
answered Nov 24 '18 at 7:42
pnutspnuts
49k764101
49k764101
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53455573%2fwant-to-extract-specific-data-to-another-cell-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1,xg6MVwmOZlhXN3xx,uhZjLCKRarhXwPyB h4GeBll
1
Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula
– usmanhaq
Nov 24 '18 at 6:10
2
Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)
– QHarr
Nov 24 '18 at 7:01
2
show us what you have tried
– Ivan Vinogradov
Nov 24 '18 at 7:53
000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM
– Jalil Cracker
Nov 25 '18 at 9:53
As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1
– usmanhaq
Nov 26 '18 at 6:11