I have a long column and I need to take out the commar between the State and
the zip code - anyone know how to do this without going into each cell??
I have a long column and I need to take out the commar between the State and
the zip code - anyone know how to do this without going into each cell??
Annette,
Select the entire range that you wish to remove the commas from. Select Ctrl-F to bring up the Find and Replace. Select the Replace Tab. In Find what: type in a comma and leave the Replace with: empty. Select Replace All. This will remove all of the commas in you range. If there are commas you want to keep then don't use this method.
Cheers,
Steve
Select your data
Edit>Replace, Find what is a comma and Replace with nothing
Press Replace all
--
Kind regards,
Niek Otten
"Annette" <[email protected]> wrote in message
news:[email protected]...
>I have a long column and I need to take out the commar between the State
>and
> the zip code - anyone know how to do this without going into each cell??
Save your worksheet first!
--
Kind regards,
Niek Otten
"Niek Otten" <[email protected]> wrote in message
news:%23p%[email protected]...
> Select your data
> Edit>Replace, Find what is a comma and Replace with nothing
> Press Replace all
>
> --
> Kind regards,
>
> Niek Otten
>
> "Annette" <[email protected]> wrote in message
> news:[email protected]...
>>I have a long column and I need to take out the commar between the State
>>and
>> the zip code - anyone know how to do this without going into each cell??
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks