Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey,
I've got a list of a couple thousand names and addresses. Unfortunately somewhere along the fields "Address Number" and "Street Name" where merged together. Whoever merged them forgot to add the " " Character inbetween. Now I have a bunch of addresses like "1234Main St.","1111Grand" and "250E 10th St.". Any idea how I can fix these? I figure I need to use a macro because I've been playing around with the text string functions and can't find any thing that will work. KCJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Address book worksheet problem | Excel Worksheet Functions | |||
Sum - Offset - Address problem. | Excel Worksheet Functions | |||
excel problem: sum(address(4,2,1):address(2,1,1)) | Excel Discussion (Misc queries) | |||
Problem using ADDRESS() in SUMPRODUCT() | Excel Discussion (Misc queries) | |||
cell address problem | Excel Discussion (Misc queries) |