ASAP Utilities, a free add-in available from www.asap-utilities.com has
features to solve both problems for you.......

Vaya con Dios,
Chuck, CABGx3



"tghcogo" wrote:


I have just converted text to columns, excellent!

However two minor complications.

1. there is a blank row btween each text row, which I don't want, and
too many to remove individually (over 2000)

2. one part of the data is a grid reference and was formerly (20,192)
now because of the delimiter being a comma it has put in two separate
columns as:

(20 and 192)

and I would like to either combine them again as before in one column
or remove the parenthisis and have them in two columns.


tx in advance


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=515708