AlbertHdez
-
Posts
1 -
Joined
-
Last visited
About AlbertHdez
-
[ms office - 2013] [Excel 2013] Data Restrictions
AlbertHdez replied to CHiLL's topic in Office Software
The simplest way is to use the SUBSTITUTE function. As an example: hyphenated name is on column A enter the following formula in an adjacent column: =SUBSTITUTE(A1,"-"," ",1)