Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cleaning Up Data
Ok i have close to 10000 records and they look like bg1234 and i need
to add 00000 after the bg but i also have to make the bg capital letters. How do i set up a marco to just look for the bg because i have other records that begin with other letters. Another problem is that i might have some records with bg123 but the i need to add 000000 after the bg . Any ideas?? Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Inconsistant Data Cleaning | Excel Discussion (Misc queries) |