Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove anything before period in column
Dear all,
I recently imported some data in excel from a .csv file only to find thta column O (containing last names) has been corrupted somehow. some last names are mixed up with the last 1 or 2 character of the middle name e.g S.Simon should really be simon. I would like to get a macro which will loop through column O and remove anything before a period. In some cases column may have 2 periods e.g M.G.Taylor when I only want Taylor. The macro should remove everything before Taylor Please assist Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove period "." from cells | Excel Discussion (Misc queries) | |||
How to sum up the value in column based on a 5 day week period? | Excel Worksheet Functions | |||
count number of dates in a column that are within a month period.. | Excel Worksheet Functions | |||
Sum column based on value in each row, if two cells equal, or if date is within time period | Excel Worksheet Functions | |||
Period to Period percentage change? | Excel Discussion (Misc queries) |