| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers to text string
Thanks, Pete.
Now, can you help with this too? COL A has 2,374 cells containing 9-character strings that look like this: 102050013 102050016 110103030 116300004 161180034 COL B contains 4,800 cells containing up to 27-characters strings that look like this: 102050001102050013 102050011102050016 106211018116040018116300004 110103012110103030 116040018116300004 161180032161180034 170212022170212025 174301015174301034174301040 174301017174301036174301041 174301034174301040 174301036174301041 174320014174320025 179221003179221008179221016 How do I search for strings in COL B that match strings in COL A? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a text string to a number | Excel Discussion (Misc queries) | |||
| How do I convert a text string into a date? | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Can i convert numbers into string format? | Excel Discussion (Misc queries) | |||
Hybrid Mode
