ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Simple Question - Please Help! (https://www.excelbanter.com/charts-charting-excel/167339-simple-question-please-help.html)

Mark31

Simple Question - Please Help!
 
I have a column of data that contains a 7 digit number in each row. I need to insert a hyphen after the 2nd number for formatting purposes for the entire column. Any easy way to do it? I am getting tired of the copy and paste. Example below

As it looks now:
990000
990001

How I need it to look:
99-0000
99-0001

Thanks.


All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com