How do I append to multiple cells in Excel?

up vote
0
down vote

favorite

For example:

If the cell's value is "ABC", I want to append "D" to it.

Suppose I have a huge list and this cell with this exact value is random throughout the list. How do I reliably append to this list?

asked Nov 15 at 17:19

Nabeel Parkar

334

Do want the cell currently with a value of ABC to have the value ABCD? If yes, you will need VBA. If the CONCATENATEd value can be in another cell, then you can use a formula
– cybernetic.nomad
Nov 15 at 17:29

add a comment |

up vote
0
down vote

favorite

For example:

If the cell's value is "ABC", I want to append "D" to it.

Suppose I have a huge list and this cell with this exact value is random throughout the list. How do I reliably append to this list?

asked Nov 15 at 17:19

Nabeel Parkar

334

Do want the cell currently with a value of ABC to have the value ABCD? If yes, you will need VBA. If the CONCATENATEd value can be in another cell, then you can use a formula
– cybernetic.nomad
Nov 15 at 17:29

add a comment |

up vote
0
down vote

favorite

For example:

If the cell's value is "ABC", I want to append "D" to it.

Suppose I have a huge list and this cell with this exact value is random throughout the list. How do I reliably append to this list?

asked Nov 15 at 17:19

Nabeel Parkar

334

For example:

If the cell's value is "ABC", I want to append "D" to it.

Suppose I have a huge list and this cell with this exact value is random throughout the list. How do I reliably append to this list?

microsoft-excel microsoft-excel-2016

asked Nov 15 at 17:19

Nabeel Parkar

334

asked Nov 15 at 17:19

Nabeel Parkar

334

asked Nov 15 at 17:19

Nabeel Parkar

334

asked Nov 15 at 17:19

Nabeel Parkar

334

asked Nov 15 at 17:19

Nabeel Parkar

334

Do want the cell currently with a value of ABC to have the value ABCD? If yes, you will need VBA. If the CONCATENATEd value can be in another cell, then you can use a formula
– cybernetic.nomad
Nov 15 at 17:29

add a comment |

Do want the cell currently with a value of ABC to have the value ABCD? If yes, you will need VBA. If the CONCATENATEd value can be in another cell, then you can use a formula
– cybernetic.nomad
Nov 15 at 17:29

Do want the cell currently with a value of ABC to have the value ABCD? If yes, you will need VBA. If the CONCATENATEd value can be in another cell, then you can use a formula
– cybernetic.nomad
Nov 15 at 17:29

add a comment |

2 Answers
2

active

oldest

votes

up vote
1
down vote

accepted

Try this short VBA macro:

Sub Macro1()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlPart, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

EDIT#1:

If you want to restrict the change to those cells whose value is exactly

ABC

then use:

Sub Macro2()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlWhole, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

Macro2() will ignore a cell like:

Easy as ABC

edited Nov 15 at 21:18

answered Nov 15 at 18:48

Gary's Student

13.2k31729

I think OP wants to consider cells with only exact value ABC. I guess your macro is generic. It will even replace ABCF with ABCDF if I am not wrong. Do comment/confirm. Thanks
– pat2015
Nov 15 at 18:53

@pat2015 See my EDIT#1
– Gary's Student
Nov 15 at 19:04

add a comment |

up vote
-1
down vote

How about the Find and Replace option (I'm looking in Excel 2016) ?
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

answered Nov 15 at 18:10

JohnC

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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',
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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375753%2fhow-do-i-append-to-multiple-cells-in-excel%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
1
down vote

accepted

Try this short VBA macro:

Sub Macro1()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlPart, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

EDIT#1:

If you want to restrict the change to those cells whose value is exactly

ABC

then use:

Sub Macro2()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlWhole, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

Macro2() will ignore a cell like:

Easy as ABC

edited Nov 15 at 21:18

answered Nov 15 at 18:48

Gary's Student

13.2k31729

I think OP wants to consider cells with only exact value ABC. I guess your macro is generic. It will even replace ABCF with ABCDF if I am not wrong. Do comment/confirm. Thanks
– pat2015
Nov 15 at 18:53

@pat2015 See my EDIT#1
– Gary's Student
Nov 15 at 19:04

add a comment |

up vote
1
down vote

accepted

Try this short VBA macro:

Sub Macro1()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlPart, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

EDIT#1:

If you want to restrict the change to those cells whose value is exactly

ABC

then use:

Sub Macro2()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlWhole, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

Macro2() will ignore a cell like:

Easy as ABC

edited Nov 15 at 21:18

answered Nov 15 at 18:48

Gary's Student

13.2k31729

I think OP wants to consider cells with only exact value ABC. I guess your macro is generic. It will even replace ABCF with ABCDF if I am not wrong. Do comment/confirm. Thanks
– pat2015
Nov 15 at 18:53

@pat2015 See my EDIT#1
– Gary's Student
Nov 15 at 19:04

add a comment |

up vote
1
down vote

accepted

Try this short VBA macro:

Sub Macro1()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlPart, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

EDIT#1:

If you want to restrict the change to those cells whose value is exactly

ABC

then use:

Sub Macro2()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlWhole, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

Macro2() will ignore a cell like:

Easy as ABC

edited Nov 15 at 21:18

answered Nov 15 at 18:48

Gary's Student

13.2k31729

Try this short VBA macro:

Sub Macro1()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlPart, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

EDIT#1:

If you want to restrict the change to those cells whose value is exactly

ABC

then use:

Sub Macro2()

    Cells.Replace What:="ABC", Replacement:="ABCD", LookAt:=xlWhole, _

        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

        ReplaceFormat:=False



End Sub

Macro2() will ignore a cell like:

Easy as ABC

edited Nov 15 at 21:18

answered Nov 15 at 18:48

Gary's Student

13.2k31729

edited Nov 15 at 21:18

answered Nov 15 at 18:48

Gary's Student

13.2k31729

answered Nov 15 at 18:48

Gary's Student

13.2k31729

answered Nov 15 at 18:48

Gary's Student

13.2k31729

I think OP wants to consider cells with only exact value ABC. I guess your macro is generic. It will even replace ABCF with ABCDF if I am not wrong. Do comment/confirm. Thanks
– pat2015
Nov 15 at 18:53

@pat2015 See my EDIT#1
– Gary's Student
Nov 15 at 19:04

add a comment |

I think OP wants to consider cells with only exact value ABC. I guess your macro is generic. It will even replace ABCF with ABCDF if I am not wrong. Do comment/confirm. Thanks
– pat2015
Nov 15 at 18:53

@pat2015 See my EDIT#1
– Gary's Student
Nov 15 at 19:04

I think OP wants to consider cells with only exact value ABC. I guess your macro is generic. It will even replace ABCF with ABCDF if I am not wrong. Do comment/confirm. Thanks
– pat2015
Nov 15 at 18:53

@pat2015 See my EDIT#1
– Gary's Student
Nov 15 at 19:04

add a comment |

up vote
-1
down vote

How about the Find and Replace option (I'm looking in Excel 2016) ?
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

answered Nov 15 at 18:10

JohnC

add a comment |

up vote
-1
down vote

How about the Find and Replace option (I'm looking in Excel 2016) ?
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

answered Nov 15 at 18:10

JohnC

add a comment |

up vote
-1
down vote

How about the Find and Replace option (I'm looking in Excel 2016) ?
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

answered Nov 15 at 18:10

JohnC

How about the Find and Replace option (I'm looking in Excel 2016) ?
https://support.office.com/en-us/article/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90

answered Nov 15 at 18:10

JohnC

answered Nov 15 at 18:10

JohnC

answered Nov 15 at 18:10

JohnC

answered Nov 15 at 18:10

JohnC

add a comment |

draft saved

draft discarded

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Gfrktyl