Rick wrote:
Have a column of data containing from the left any number of dots
followed by a number.
The columns can contain anywhere from none, to up to 25 dots, and
followed by a number ranging from 1 to 2500.
Am looking for a formula to display just the number without the dots
in a column on another worksheet
For example:
.........64 would display as 64
..456 would display as 456
.....................22 would display as 22

Looked at SUBSTITUTE, LEN, TRIM, and all I'm getting for results is a
partial or a headache.

Thanks for any ideas.

Rick


SUBSTITUTE should work.

=SUBSTITUTE(A1,".","")

If not, describe your results.