LinkBack URL
About LinkBacks
in Excel 2010
I am trying to do a data validation so that a cell is in the following format:
xxx.xxx.xx.xxxx.xxx
The "x's" can be either alpha or numeric but is has to be the proper number of characters separated by the periods.
in Excel 2010
I am trying to do a data validation so that a cell is in the following format:
xxx.xxx.xx.xxxx.xxx
The "x's" can be either alpha or numeric but is has to be the proper number of characters separated by the periods.
A bit of a work around..
Since without the "." the length of your string is 15
- Use in data validation -- text length -- equal to -- 15
- In a separate cell use
Does this help?
=REPLACE(REPLACE(REPLACE(REPLACE(A1,4,0,"."),8,0,"."),11,0,"."),16,0,".")
Life's a spreadsheet, Excel!
Say thanks, Click *
use this with data validation or conditional formatting
Formula:
=match("???.???.??.????.???",e7,0)
there may be anywhere from 1-30,000 rows however so wil it work that way also?
Apply conditional formatting to the entire column, that way when you add more data to your spreadsheet, the conditional formatting will already be there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks