Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Text Replace
I create documents every day for about 100 users and I am trying to figure
out how to modify a column. The column populates like this ToJo-8:05: or ToJo-12:30. The first 4 characters and time will be different for every person. I want all the cells to look like the second example. So basically users created in single digit hours, I have to manually go in and change them from ToJo-8:05: to ToJo-08:05 Is there a formula or replace command I can use to make this change automatically and not mess up the already correct ones (like ToJo-12:30)? Thanks a bunch!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
Excel: replace all 2 spaces to FF/LR in column of text | Excel Discussion (Misc queries) | |||
Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
How do I search and replace text in a textbox in Excel? | Excel Discussion (Misc queries) | |||
Excel - Find & Replace text in a string | Excel Worksheet Functions |