Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Word Formating & Words Adding
i) In column A is my product series as "18-65-85", "18-1-98", "18-656-74" and
etc. Now, I would like make it all in standard as "18-0065-85", "18-0001-98" "18-065 6-74" and etc. What's faster way? ii)Now in column B is my product code as "PO-484P", "PP-65P", "HB-K5P", etc. Now, I would like to add an "A" in every code to be "APO-484P", "APP-65P", "AHB- K5P", etc... What's faster way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Help with date formating when export to Word | Excel Discussion (Misc queries) | |||
How do you sort words in Excel by the number of letters in a word | New Users to Excel | |||
Finding Words In Excel Spreadsheets & Word Documents | Excel Discussion (Misc queries) | |||
Adding words up in a range | Excel Discussion (Misc queries) |