Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace ('S) with ('s) within an excel list of company na
I used proper() on a list of company names and addresses. the company that
included a ('s) got changed to ('S). The direction in the addresses got changed from (SW) to (Sw). I tried to find and replace but the find did not recognise ('s) or (Sw). I even setup another column and used copy and paste special values to permentely change the data from that was changed with Proper(). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace ('S) with ('s) within an excel list of company na
Try this: 1. Control + H to pull up replace dialogue box. 2. Click on the Options button to see the extended options. 3. Select Match Case. It should work now. -- MartinShort Software Tester ------------------------------------------------------------------------ MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034 View this thread: http://www.excelforum.com/showthread...hreadid=548634 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace ('S) with ('s) within an excel list of company na
Using the Find and Replace feature........find ~'S, replace with 's..........
find Sw, replace with SW works for me in XL97 Vaya con Dios, Chuck, CABGx3 "John1521" wrote: I used proper() on a list of company names and addresses. the company that included a ('s) got changed to ('S). The direction in the addresses got changed from (SW) to (Sw). I tried to find and replace but the find did not recognise ('s) or (Sw). I even setup another column and used copy and paste special values to permentely change the data from that was changed with Proper(). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace value in excel? | Excel Worksheet Functions | |||
CREATE LIST OBJECT IN EXCEL | Excel Worksheet Functions | |||
Excel - Find & Replace text in a string | Excel Worksheet Functions | |||
Excel List range, filter arrows disappeared | Excel Discussion (Misc queries) | |||
Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions |