| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace
I have a column of road names with abbrevations for words like "Circle" is
"Cr". there are over 75,000 total road names. If I do a replace on "Creekside Cr" it changes it to "Circleeekside Circle" How do I "Replace all" without changing the first word? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and Replace
The logic depends on what is to be replaced. For the example given below
Find what " Cr" (a space followed by Cr) Replace with " Circle" (a space followed by Circle) If this post helps click Yes --------------- Jacob Skaria "Toonigh" wrote: I have a column of road names with abbrevations for words like "Circle" is "Cr". there are over 75,000 total road names. If I do a replace on "Creekside Cr" it changes it to "Circleeekside Circle" How do I "Replace all" without changing the first word? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and Replace
put a space before "Cr" in Find What
and a space before "Circle" in Replace With HIH On 28 Paź, 14:01, Toonigh wrote: I have a column of road names with abbrevations for words like "Circle" is "Cr". there are over 75,000 total road names. If I do a replace on "Creekside Cr" it changes it to "Circleeekside Circle" How do I "Replace all" without changing the first word? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and Replace
.... but of course you'd sstill have a problem with "Jacob's Creek Drive", or
whatever. -- David Biddulph "Jarek Kujawa" wrote in message ... put a space before "Cr" in Find What and a space before "Circle" in Replace With HIH On 28 Paz, 14:01, Toonigh wrote: I have a column of road names with abbrevations for words like "Circle" is "Cr". there are over 75,000 total road names. If I do a replace on "Creekside Cr" it changes it to "Circleeekside Circle" How do I "Replace all" without changing the first word? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and Replace
Hi,
Highlight the range with the information, hit CTRL H, where it says find what enter CR , and replace with enter Circle, then click on replace all "Toonigh" wrote: I have a column of road names with abbrevations for words like "Circle" is "Cr". there are over 75,000 total road names. If I do a replace on "Creekside Cr" it changes it to "Circleeekside Circle" How do I "Replace all" without changing the first word? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Find and Replace
.... and in what way does that avoid changing the first word, Eduardo?
-- David Biddulph "Eduardo" wrote in message ... Hi, Highlight the range with the information, hit CTRL H, where it says find what enter CR , and replace with enter Circle, then click on replace all "Toonigh" wrote: I have a column of road names with abbrevations for words like "Circle" is "Cr". there are over 75,000 total road names. If I do a replace on "Creekside Cr" it changes it to "Circleeekside Circle" How do I "Replace all" without changing the first word? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| Find and replace results can the appearance of find be different? | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Hybrid Mode
