Need help with Find and Replace with multiple cell rows

kevindj71

New Member
Joined
Apr 15, 2016
Messages
23
This could be a novice question, but I am looking to Find/Replace all in a column where there are multiple rows of data. A standard F/R will find okay, but entirely replace the other data I need to remain in the cell. Example below.

Find: 10423402039

Replace only the match with: 10423402060


Before cell result:
10116000914
10423402040
10423402039
10116000914

Needed after cell result:
10116000914
10423402040
10423402060
10116000914
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

alz

Board Regular
Joined
Jul 17, 2020
Messages
130
Office Version
  1. 2019
Platform
  1. Windows
Select the range first where you want to find and replace

Replace will apply on selected cell only . if you do not select range ,Replace will apply on the whole sheet.
Check on Match on entire cell content
 

Attachments

  • Screenshot (39).png
    Screenshot (39).png
    16 KB · Views: 1

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,412
Office Version
  1. 365
Platform
  1. Windows
It should only replace the search value, not the entire cell content. Are you including any wild cards with the search value?
 

kevindj71

New Member
Joined
Apr 15, 2016
Messages
23
It should only replace the search value, not the entire cell content. Are you including any wild cards with the search value?
Correct, I don't want to replace the entire cell content, only the search value. I am not including any wildcard.

1611158103101.png
 

kevindj71

New Member
Joined
Apr 15, 2016
Messages
23

ADVERTISEMENT

Select the range first where you want to find and replace

Replace will apply on selected cell only . if you do not select range ,Replace will apply on the whole sheet.
Check on Match on entire cell content
Checking match entire cell content yields no results since it's not an exact match in this case.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,412
Office Version
  1. 365
Platform
  1. Windows
Correct, I don't want to replace the entire cell content, only the search value. I am not including any wildcard.
In that case it should work quite happily.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,412
Office Version
  1. 365
Platform
  1. Windows
I've no idea why that is, as it should just replace the value you searched for.
 

kevindj71

New Member
Joined
Apr 15, 2016
Messages
23
Turns out to be user error... The original data was displayed as a single line of data, but once the F/R happened, the appearance/view changed to one string per line within the cell. I just didn't change the row height or look closely at the formula bar.

Before:
1611176327495.png


After:
1611176428444.png
 
Solution

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,412
Office Version
  1. 365
Platform
  1. Windows
Glad you sorted it & thanks for the feedback.
It would appear that the replace is automatically turning "Wrap Text" on.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,348
Messages
5,624,145
Members
416,014
Latest member
MickP69

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top