If comma present, then place a character before and after comma (FORMULA)

**jaimealvarez** · 06-21-2012, 03:23 PM

Hi,
So what I'm looking for is a formula that first looks for a comma, if there is a comma then place a ' before and after the comma, if not then just brings the value from that cell (always placing a ' at the start and ending of the value).

So final product should be

4323 is '4323'
4323,5824 is '4323','5824'

Any hel would be appreciated.
Thank you

**tigeravatar** · 06-21-2012, 03:44 PM

jaimealvarez,

Give this a try:

Please Login or Register  to view this content.

**jaimealvarez** · 06-21-2012, 04:01 PM

It worked! Thanks so much

**tigeravatar** · 06-21-2012, 04:04 PM

You're very welcome

If comma present, then place a character before and after comma (FORMULA)

LinkBack

Thread Tools

Rate This Thread

Display

If comma present, then place a character before and after comma (FORMULA)

Re: If comma present, then place a character before and after comma (FORMULA)

Re: If comma present, then place a character before and after comma (FORMULA)

Re: If comma present, then place a character before and after comma (FORMULA)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions