ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find and Replace on just One Column (https://www.excelbanter.com/excel-discussion-misc-queries/102336-find-replace-just-one-column.html)

BookerW

Find and Replace on just One Column
 
I want to do a replace all , but i only want to apply it to one column. Is
that possible? nd if so, how would I restrict it to just one column.

Dave Peterson

Find and Replace on just One Column
 
Select that single column first.

Then edit|replace

BookerW wrote:

I want to do a replace all , but i only want to apply it to one column. Is
that possible? nd if so, how would I restrict it to just one column.


--

Dave Peterson

Ron Coderre

Find and Replace on just One Column
 
Try this:

FIRST...select the entire column (by clicking the column heading letter)

THEN...execute the <edit<replace

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BookerW" wrote:

I want to do a replace all , but i only want to apply it to one column. Is
that possible? nd if so, how would I restrict it to just one column.



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

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