Add string only if a text is present in a cell
Solved/Closed
Related:
- Add string only if a text is present in a cell
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to add a tick in word - Guide
- How to add photo in word resume - Guide
- How to add songs to sound picker - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 29, 2015 at 02:05 PM
Jun 29, 2015 at 02:05 PM
Deloro, Good afternoon.
Try to use :
=IF(B5<>"";CONCATENATE(MID(B5;1;1);".");"")
Is this what you want?
I hope it helps.
Try to use :
=IF(B5<>"";CONCATENATE(MID(B5;1;1);".");"")
Is this what you want?
I hope it helps.
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jun 30, 2015 at 10:36 AM
Jun 30, 2015 at 10:36 AM
Deloro, Good morning.
Please, open another post to present your new question.
Using a SOLVED post With another question, dificult people to help you.
Have a nice day.
Please, open another post to present your new question.
Using a SOLVED post With another question, dificult people to help you.
Have a nice day.
Jun 30, 2015 at 03:19 AM
Jun 30, 2015 at 06:52 AM
now i have his string:
=CONCATENATE(CONCATENATE(UPPER(A55));(CONCATENATE(UPPER(B55);" ";UPPER(C55))))
the fields contain names:
name 1 (A55), name 2 (B55) and surname (C55)
with name 1 and surname i have te result as: Name1 Surname
but with name 1 name 2 and surname i have this: Name1Name2 Surname
so i need a space between name 1 and name 2. how can i have a space after name 1 (or before name 2) only if name 2 is present? (i tried but it adds a double space if name 2 is not present..)
i can't figure out how to write it..
Thanks
Jun 30, 2015 at 08:36 AM
=CONCATENATE(CONCATENATE(UPPER(IF(D55<>"";CONCATENATE(UPPER(C55);" ");CONCATENATE(UPPER(C55))));IF(D55<>"";CONCATENATE(UPPER(D55);" ");" ");UPPER(E55)))