Hi guys,
How can I have a formula and text in the same?
i.e
=TRIM(LEFT('Sheet2'!A2,36))
AND
text: This is my text
Please help.
Many thanks as always!
Hi guys,
How can I have a formula and text in the same?
i.e
=TRIM(LEFT('Sheet2'!A2,36))
AND
text: This is my text
Please help.
Many thanks as always!
Thanks,
R.
this .. ???
=TRIM(LEFT('Sheet2'!A2,36)) & " this is my text"
Try
=TRIM(LEFT('Sheet2'!A2,36))&"This is my text"
or
=CONCATENATE(TRIM(LEFT(Sheet2!A2,36)),"This is my text")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Ta John, this works!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks