This formula will get the values which is present before the first comma.
=LEFT(A1,FIND(",",A1)-1)

This function will replace all the comma and get you the values without
commas.
=SUBSTITUTE(A1,",","")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"ss" wrote:

On Dec 3, 9:19 pm, Ms-Exl-Learner wrote:
=INDEX(A1:A65535,MAX(ROW(A1:A65535)*(A1:A65535<"" )))

Copy and paste the above formula and give F2 and press CNTRL+SHIFT+ENTER,
since it is an array formula.

Change the cell reference to your desired cell, if required.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------



"jcheko" wrote:
need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day, it should be able to identify the next cell if I add a value to the
column. for your help I am very thankfull.- Hide quoted text -

- Show quoted text -

Hi

I have a column that contain all the values end with comma,but i want
to remove comma from last cell value only.
Please suggest me to get this.

ex:

cell A

aa,
bb,
cc,

I want to remove comma from only "cc," value
.