LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
meesh1224
 
Posts: n/a
Default Find and replace error

I have a worksheet that was created by pasting in data from a word table. I
am in the process of cleaning up the data which will in turn be used to
populate a database. As part of my clean up I am using the find and replace
function to take out commas. Some of the text is lengthy. When I get to a
lengthy cell, Excel is giving me an error stating that the formula is too
long.
Thoughts? Work arounds?

Thanks,
Michelle
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find replace ??* Todd Excel Worksheet Functions 0 January 25th 05 11:35 PM
macro to Find Replace in Excel Nurddin Excel Discussion (Misc queries) 7 January 3rd 05 04:29 AM
Find & Replace results to display specified chosen fields samuel Excel Discussion (Misc queries) 1 December 28th 04 08:43 AM
Find and Replace? Intotao Excel Worksheet Functions 11 December 12th 04 07:33 PM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 05:45 PM


All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"