arrow_back 返回自由职业
F

Excel Date & Text Cleanup

Freelancer

分享:
placeIN home_work远程 assignment合同制 public聚合职位 · IN

event发布于 2026年8月31日 · verified我们于 2026年8月31日 确认该职位仍然有效

₹ 12.500 – ₹ 37.500 (每个项目)

职位介绍

I need a tidy-up pass on an existing Excel workbook. Two things have to happen: 1. Every date column must have the month-and-year extracted into its own field (for example, “15/04/2024” should become “Apr-2024”). Please preserve the original date values so the sheet continues to calculate correctly. 2. Text columns contain stray leading or trailing spaces. Those spaces have to be trimmed so that look-ups and pivots work properly, while leaving all other characters intact. Feel free to use formulas, Power Query, or a lightweight VBA routine—whatever is quickest and still keeps the file fully editable in Excel 2016 or later. Send me back: • The cleaned workbook with both the original and the newly formatted columns visible • A short note (or worksheet tab) outlining the exact steps or code you used, so I can repeat the process on future data drops. Once I can reproduce your method and the sheet shows the correct month-year values with all text fields trimmed, the job is done.

继续免费阅读

创建免费账户以查看完整职位信息并申请。

  • badge作品集对企业可见
  • notifications新职位邮件提醒
  • favorite始终免费,无任何隐藏条件