I have some cells with a leading comma as the first character in a column.
Is there a formula to detect if there is a comma as the first character in the cell, and if found remove it?
I have some cells with a leading comma as the first character in a column.
Is there a formula to detect if there is a comma as the first character in the cell, and if found remove it?
Hi,
Have you tried using Find/Replace, find comma, replace - leave it blank
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
The trouble is the cells also include other commas that I want to leave in place.
I only want to remove a leading comma if it exists, not all commas in the cell.
Hi,
Try this in B1 copied down
=IF(ISERROR(IF(FIND(",",A1),MID(A1,2,100))),A1,IF(FIND(",",A1),MID(A1,2,100)))
Addendum: The 100 allows for the number of characters in the sentence, if more increase it.
Last edited by oldchippy; 06-21-2010 at 05:32 PM. Reason: Addendum
Or = MID(A1, (LEFT(A1)=",") + 1, LEN(A1))
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks