Prev: Returning a label rather than a number in pivot table field
Next: Autofill from Data Validation
From: Curtis on 10 Mar 2010 09:49
I have numbers separated by Hyphen(s) and I am looking for an easy way to
remove the Hyphen and just leave the text

My data could be

1410-4031 or 1469-1555-043

Thanks

--
ce
From: Pete_UK on 10 Mar 2010 09:57
Highlight the cells and use Find & Replace (CTRL-H) - Find hyphen and
replace with nothing.

Hope this helps.

Pete

On Mar 10, 2:49 pm, Curtis <curtis.ea...(a)yahoo.ca> wrote:
> I have numbers separated by Hyphen(s) and I am looking for an easy way to
> remove the Hyphen and just leave the text
>
> My data could be
>
> 1410-4031 or 1469-1555-043
>
> Thanks
>
> --
> ce

From: Iriemon on 10 Mar 2010 10:37
Do a find and replace (Cntrl H) and replace the "-" with nothing ("-" without
the qoutes)



"Curtis" wrote:

> I have numbers separated by Hyphen(s) and I am looking for an easy way to
> remove the Hyphen and just leave the text
>
> My data could be
>
> 1410-4031 or 1469-1555-043
>
> Thanks
>
> --
> ce
 | 
Pages: 1
Prev: Returning a label rather than a number in pivot table field
Next: Autofill from Data Validation